Data dodania Pytanie
2017-02-28 18:02 oracle filter on explain plan partitions »
I'm making a proof of concept and I'm experimenting a strange behaviour. I have a table partitioned by range by a date field and the cost of a query c...
(1) odpowiedzi
2017-02-28 14:02 how update result of big query in oracle? »
Can I update the result of query easily? Assume I have big query which returns salary column and I need update salaries based on this query results. ...
(2) odpowiedzi
2017-02-27 21:02 How to Fast Refresh on a Materialized View with Joins and Aggregates? »
Suppose I have two tables job and batch: CREATE TABLE batch ( batch_id NUMBER(20) PRIMARY KEY, batch_type NUMBER(20), [some other values] ......
(1) odpowiedzi
2017-02-27 20:02 Async/Non-blocking Query in sqldeveloper »
I have a long running (simplified) query like: BEGIN FOR i in (SELECT * FROM T WHERE ....) LOOP DMBS_OUTPUT.PUT_LINE(i.VALUE); END LOOP; EN...
(2) odpowiedzi
2017-02-27 16:02 SQL Select counter when values change »
I need to make a counter for everytime a value changes in time. I have this table: Date | Quantity 2017-02-01 | 10000 2017-02-02 | 2...
(2) odpowiedzi
2017-02-26 22:02 Select a random number representing a row »
How can i make this thing in PL/SQL? I want to generate a random number, which will represent a position (row) from a list of results, which will be ...
(4) odpowiedzi
2017-02-26 11:02 XMLAGG - ORA-00932: inconsistent datatypes: expected - got CLOB on CLOB »
I have the following SQL query: SELECT DISTINCT prod_no, prod_text, RTRIM ( XMLAGG (XMLELEMENT (e, prod_de...
(1) odpowiedzi
2017-02-26 06:02 (Oracle) How to get sum value inside loop? »
I need value of sum inside loop. DECLARE VAR_PCT NUMBER; CURSOR C1 IS SELECT A, B FROM TBL; BEGIN FOR REC1 IN C1 LOOP --This where i need the valu...
(1) odpowiedzi
2017-02-25 12:02 Error while calling stored procedure through php. Literal does not match format string »
I am using Oracle 10g Express Edition with PHP codeigniter. I have a table tbl_movie:- CREATE TABLE tbl_movie (movie_id NUMBER(11) PRIMARY KEY, mo...
(2) odpowiedzi
2017-02-25 10:02 literal does not match format string ORA-06512 »
I am using Oracle 10g with PHP codeigniter. I have a stored procedure which I have run through command line via SQL Command Line. Here is my procedu...
(0) odpowiedzi
2017-02-25 07:02 How to call procedure that contain SYS_REFCURSOR »
I create the procedure to output multi rows and columns. create or replace PROCEDURE MYPROC( C1 OUT SYS_REFCURSOR ) AS BEGIN OPEN C1 FOR SELECT...
(1) odpowiedzi
2017-02-24 17:02 How to remove specific value from comma separated string in oracle »
I want remove specific value from comma separated sting using oracle. Sample Input - col 1,2,3,4,5 Suppose i want to remove 3 from the string. S...
(5) odpowiedzi
2017-02-24 16:02 Doing a quick count? »
I already have my select query of data and I want a quick count of how many rows my select query will return. Is there a way to do this instead of tak...
(2) odpowiedzi
2017-02-24 15:02 How to make this Oracle select statement perform faster? »
Could any please advise on how to make this query perform faster than it is at the moment? T2.ADI is indexed on TABLE2 T1.ADI is indexed on TABLE1 T...
(1) odpowiedzi
2017-02-23 22:02 I have created CHECK constraint but receiving error message »
create sequence student_studentid_seq increment by 10 start with 100 nocycle; create table student (studentid number(10), name varchar2(30) not null...
(1) odpowiedzi
2017-02-23 19:02 Oracle pivot a table based on column value using like »
sample table Child Parent FF00001 12345 AA00002 12345 GG00003 12345 TT00003 12345 What I want is a table like this Parent FF AA ...
(1) odpowiedzi
2017-02-23 12:02 Oracle PL/SQL Bubble-Sorting - ORA-01403: no data found ORA-06512: at line 12 »
Here is the code: declare p_arr dbms_sql.Number_Table; i pls_integer; procedure do_sort(p_arr in out dbms_sql.Number_Table, p_asc in bool...
(1) odpowiedzi
2017-02-23 11:02 what is better approach to handle Oracle Cursor results »
I got old code to refactor and to add new functionalities. While browsing thru code I saw many builders that makes code very dirty in my opinion. And...
(0) odpowiedzi
2017-02-22 21:02 ORA - 00936 error but anable to find what is missing in line 2 »
I'm trying to execute this code but it says i'm missing something in row_number() expression which I'm not able to figure out at all. with summary as...
(2) odpowiedzi
2017-02-22 15:02 Oracle Tree Structure Hierarchy Data Display in Single Row Different Column »
I have a hierarchical table named Employee_Hierarchy in oracle with column names entity_code, parent_entity_code, entity_name and entity_role with no ...
(4) odpowiedzi
2017-02-22 15:02 Linq Orderby vs SQL Orderby »
I have a table column (Varchar) with the following data : COLUMN_NAME 102100 1-2000 112100 When I use OrderBy in the SQL statement, I get the...
(2) odpowiedzi
2017-02-21 22:02 resultSet.next() : Does it fetch data from buffer OR from database? »
I have a code like this below, try (Connection connection = this.getDataSource().getConnection(); PreparedStatement statement = connection.p...
(2) odpowiedzi
2017-02-21 14:02 Ruby Table Data Structure to PL/SQL »
Is there a way in Ruby to populate a table of data that would then be passed to a stored procedure? Essentially what I'm trying to do is something li...
(1) odpowiedzi
2017-02-21 14:02 ORA-00922 When trying to place table in memory »
I've two environments, Oracle 12.1.0.2.0 - 64bit, which are basically identical. In one I could successfully place the tables I wanted in memory, but ...
(1) odpowiedzi
2017-02-21 12:02 SQL ROLLUP or Union? »
I am trying to get the grand total number of entries but unfortunately I am not convinced rollup would be the best choice: SELECT BUSINESS_STATUS_NAM...
(2) odpowiedzi
2017-02-20 12:02 Workaround for %ROWTYPE in Object type »
I'm new to PL/SQL and trying to create an object with a reference to a table row: CREATE OR REPLACE TYPE my_object AS OBJECT( table_row my_table%RO...
(2) odpowiedzi
2017-02-20 11:02 SQL Developer bind variables prompt: force string values »
I'm trying to use SQL Developer bind variables prompt to speed up query execution, but I'm not getting the desired output: looks like the values I put...
(1) odpowiedzi
2017-02-20 04:02 How to retrieve records from to columns into a single column in order? »
I have a table containing two columns. I need to retrieve the contents of two columns into one single column in order using Oracle query. FirstName ...
(2) odpowiedzi
2017-02-19 12:02 What is the point using "AS" keyword in SQL when aliasing can be done without it? »
Select salary*12 as "Annual Salary" from Employee; Select salary*12 "Annual Salary" from Employee; Both queries will give the same result, would "...
(3) odpowiedzi
2017-02-19 12:02 ORA-00998: must name this expression with a column alias »
I get that I should add alias with all the columns and I'm doing so but I'm still getting error. CREATE TABLE MENTIONS AS SELECT UM.USER_ID AS U...
(2) odpowiedzi
2017-02-19 09:02 Execute Immediate on DDL Statements »
I executed the following code in Oracle Database but faced with an error of the view name does not exist. Can anyone look into it ? Declare Stmt var...
(2) odpowiedzi
2017-02-18 11:02 Trying to create table using execute immediate »
i am trying to create a table using below code. set serveroutput on; DECLARE cursor c1 is select '''create table demo1 (demo varchar2(100))''' c2 fr...
(1) odpowiedzi
2017-02-18 06:02 fill zero value from function result with case statement »
i have this query in oracle : WITH LOANS_PRINCIPAL AS (SELECT MASKAN_RATE.RATE, HRS.FN_GETREMIND_BY_DATE(PERSON_DOCK.ID,'2016/01/01') AS...
(1) odpowiedzi
2017-02-18 06:02 Oracle Flashback Data Archive Version Query With Join? »
I have a situation in where I am trying to essentially get a list of all changes that have occurred on a dataset between two points in time. This seem...
(0) odpowiedzi
2017-02-17 16:02 REGEXP_SUBSTR with negative position »
I have a query to treat comma as delimiter in a string. I want to substr the last occurrence. example: string: a, b, c, d string: e, f, g,...
(4) odpowiedzi