Data dodania Pytanie
2017-03-07 08:03 Query for schedule date comparison »
I have a table like this: account number(repeat) | schedule_due_date ---------------------- | ----------------- 111 | '01-FEB-2017...
(2) odpowiedzi
2017-03-06 16:03 SQL - find exact group of records in large table »
I have following data: ID --- GRP_ID --- REC_VAL 1 --- 1 --- A 2 --- 2 --- A 3 --- 2 --- B 4 --- 3 --- A 5 --- 3 ...
(1) odpowiedzi
2017-03-06 14:03 How to extract XML Value in Oracle Database »
I have a table in an Oracle 12c Database that contains a XML Type Column and i need to extract a value from this Column. Here an example of this Colum...
(1) odpowiedzi
2017-03-06 12:03 What will be the ORA code if the Stored Procedure executes nothing? »
I have a Stored Procedures which I am calling from Java code. There is an IF block and that IF condition is false the procedure executes nothing. So w...
(2) odpowiedzi
2017-03-05 21:03 Best method to select values present in one table but missing in another one? ORACLE »
My solution: Table name : HW1_PERSON, hw1_sfaff SELECT I.ID,person.person_id FROM HW1_PERSON LEFT JOIN HW1_STAFF ON I.ID=person.person_id WHERE ...
(2) odpowiedzi
2017-03-05 17:03 Concat function is not working - invalid number of arguments »
I have a table with two columns(Name, Occupation). I want to output the value in a format something like this. Jane(A) Jenny(D) Julia(A) Hear Fir...
(2) odpowiedzi
2017-03-05 16:03 LISTAGG alternative in Oracle 10g »
I am kind of newbie in Oracle. Got stuck in the below: I have the below 2 tables: Site: **SiteID|SiteName** 1 Sydney 2 Newyork 3 Del...
(3) odpowiedzi
2017-03-04 19:03 return only sequentially numbered values from oracle »
I have an sql query using the listagg function to create a comma separated list into one returned field which is working correctly. But I'd like to o...
(1) odpowiedzi
2017-03-04 15:03 (Oracle SQL) How to display info about customers that made orders in two years? »
I have a table named Orders where There are information about customers and their orders made and I want to retrieve information only customers made o...
(4) odpowiedzi
2017-03-04 07:03 Inconsistent behavior with `CROSS APPLY` and `OUTER APPLY` »
I have a schema in Oracle-12c similar to a typical forum with accounts, posts, comments. I am writing a single query to get... one user all that use...
(2) odpowiedzi
2017-03-03 23:03 What is special about com.oracle:ojdbc6 in version 11.2.0.3? »
Because of Oracle licensing policy each organization import Oracle JDBC driver into in-house Repository Manager. But com.oracle:ojdbc6 at version 11....
(1) odpowiedzi
2017-03-03 14:03 Calculate sum time in Oracle »
I have this table in Oracle, email and time are varchar. Email Time ---------------- ----------- paolo@gmail.com 00:10:40 paolo@...
(1) odpowiedzi
2017-03-03 09:03 Select single row with multiple rows in joined table »
I have a contact table as below: contactid | contactname ----------|------------- C1 | Name1 C2 | Name2 I have a communication ...
(2) odpowiedzi
2017-03-02 21:03 find column names and table names referenced in SQL »
How to find all the tables and column names used in a SQL? It is on ORACLE database. Below is an SQL example. SELECT A.ENAME, A.AGE as EMP_A...
(3) odpowiedzi
2017-03-02 19:03 Joining a record from a single column date range »
I have two tables: Person +---------+-----------+ | Name | Added | +---------+-----------+ | Roger | 2/1/2001 | | Natalie | 5/5/2001 | | G...
(3) odpowiedzi
2017-03-02 19:03 How to access the structure and get the column list ,datatypes of refcursor? »
I have a procedure which gets me the output with refcursor and data/structure in cursor will be dynami. Each time depending on inputs datatypes and no...
(2) odpowiedzi
2017-03-01 19:03 SQL - Order By Subtotal Count in a Grouping Set »
This is my current statement: SELECT COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5, COUNT(*) COUNTER FROM TABLE GROUP BY GROUPING SETS ...
(1) odpowiedzi
2017-03-01 13:03 Preserve Special Charcters While Migrating Data »
I am using the below code to extract data from source legacy database and putting into a CLOB column in target 11g database RTRIM ( XML...
(1) odpowiedzi
2017-03-01 09:03 self split insert in oracle interval partition »
i have very strange problem. i have some insert into interval partition table. The insert take a long time - but the interesting thing is that after...
(0) odpowiedzi
2017-02-28 23:02 Groovy Oracle Stored Proc - invaid column index »
sql.call("StoredProcName", [Sql.resultSet(OracleTypes.CURSOR)]) { table -> table.eachRow { row-> println row } }...
(1) odpowiedzi
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