OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
db link between 10g and 12c 10g 12c By: mshrkshl on Tue, 19 January 2016	4	5103	Wed, 20 January 2016 04:25 By: Littlefoot
Use cursor output in the IN CLAUSE 11.2.1.0 By: OraFerro on Tue, 19 January 2016	4	1050	Tue, 19 January 2016 13:48 By: Barbara Boehmer
ora-12096 Oracle 11.2.0.4, Windows 2008 R2 By: sant_new1 on Mon, 18 January 2016	22	4819	Tue, 19 January 2016 13:32 By: sant_new1
How do I find a value anywhere in a Oracle schema ? 12c By: gorants on Mon, 18 January 2016	15	10110	Tue, 19 January 2016 10:08 By: gorants
VARCHAR2 Convert to H:MI:SS tt (merged 2) Windows server 2008r2 By: farrukh786 on Mon, 18 January 2016	28	4035	Tue, 19 January 2016 03:11 By: Michel Cadot
CHAR ' ORACLE 6i By: NNAAEE on Thu, 14 January 2016	11	1942	Mon, 18 January 2016 08:38 By: EdStevens
SQL Query Oracle 10g By: swapnil_naik on Mon, 18 January 2016	6	1122	Mon, 18 January 2016 04:24 By: Michel Cadot
ANSI SQL STATEMENTS By: Danny Freeman on Fri, 15 January 2016	3	2105	Sun, 17 January 2016 08:26 By: Solomon Yakobson
How to use minus, union for CLOB datatype column in Oracle? Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: Oracle_Walker on Thu, 14 January 2016	12	7864	Sat, 16 January 2016 06:56 By: Solomon Yakobson
interview question oracle 10g By: san-deep on Fri, 15 January 2016	5	1467	Fri, 15 January 2016 12:43 By: pablolee
Odd case of removing duplicates within a set. Oracle, 11.2.0.4.0, Windows 7 By: tmcallister on Fri, 08 January 2016	6	1632	Thu, 14 January 2016 08:53 By: Solomon Yakobson
how to write below procedure By: ram7aj1a0235 on Tue, 12 January 2016	8	1680	Wed, 13 January 2016 04:00 By: pablolee
To Log DBMS in a file from procedure By: rohit_shinez on Thu, 07 January 2016	9	2254	Tue, 12 January 2016 12:00 By: Bill B
Not able to create the Materialized view 11.2.0.4 By: grpatwari on Mon, 04 January 2016	7	4643	Tue, 12 January 2016 01:00 By: Michel Cadot
Not able to insert with returning option on view with instead of trigger 11g By: saini006 on Mon, 11 January 2016	3	2264	Mon, 11 January 2016 22:33 By: Kevin Meade
Pull 20 records for each time Oracle Pl/sql By: itnagaraj on Mon, 11 January 2016	8	1609	Mon, 11 January 2016 08:46 By: cookiemonster
Generate unique combinations Oracle 11g By: Xandot on Fri, 08 January 2016	2	814	Fri, 08 January 2016 08:15 By: Xandot
Case statement for multiple options By: blyzz on Thu, 07 January 2016	3	1194	Fri, 08 January 2016 02:54 By: cookiemonster
Joining on optional TABLE OF NUMBER parameters Oracle 11G By: Sam D. on Mon, 28 December 2015	17	3214	Thu, 07 January 2016 13:21 By: Sam D.
Interesting problem with query Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: javon13 on Wed, 06 January 2016	10	1995	Thu, 07 January 2016 08:13 By: cookiemonster
repeat the previous value to next rows oracle 11g By: guddu_12 on Wed, 06 January 2016	1	1294	Wed, 06 January 2016 12:20 By: Michel Cadot
NVL Function By: johnsid on Tue, 05 January 2016	3	1313	Wed, 06 January 2016 07:23 By: javon13
Query is not running from 11.2.0.3 to 11.2.0.4 11.2.0.4 By: grpatwari on Mon, 04 January 2016	18	3119	Wed, 06 January 2016 03:35 By: cookiemonster
XML parsing error-ORA-06512 oracle 10g By: gobi21 on Tue, 05 January 2016	4	7867	Tue, 05 January 2016 21:50 By: gobi21
Collections- Associative arrays Oracle, 11.2.0.4.0, Windows 7 Professional By: buggleboy007 on Sun, 03 January 2016	14	2123	Mon, 04 January 2016 09:49 By: Michel Cadot
Getting ORA-01839: date not valid for month specified Oracle 11g By: shuklajayb4 on Thu, 31 December 2015	5	2432	Mon, 04 January 2016 03:00 By: cookiemonster
Help me on Syntax of PL/SQL PL/SQL using UNIX scripts By: royal4111 on Thu, 24 December 2015	6	1714	Thu, 31 December 2015 21:59 By: royal4111
Can't create a Materialised view Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: brown_zzz on Thu, 31 December 2015	2	897	Thu, 31 December 2015 04:47 By: brown_zzz
Performance Issue in VARRAY oracle 11G By: ramchandru1989 on Wed, 30 December 2015	4	3211	Thu, 31 December 2015 03:57 By: John Watson
Please help - pivot option oracle 11g, linux By: lb92 on Wed, 30 December 2015	5	1551	Wed, 30 December 2015 11:46 By: lb92
Please help for resolving issue for UTL_FILE Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Mon, 28 December 2015	7	1571	Tue, 29 December 2015 08:35 By: Bill B
Can we Write PLSQL concept in WITH clause oracle 11g By: graphe on Fri, 27 November 2015	14	2850	Tue, 29 December 2015 07:43 By: EdStevens
Materialized View Window 10, 11G By: Bilal Khan on Mon, 28 December 2015	4	1572	Mon, 28 December 2015 04:01 By: John Watson
Start DB session using sh script with out the password 10g Release 2 By: arunprakash647 on Wed, 25 September 2013	7	3344	Fri, 25 December 2015 06:18 By: Michel Cadot
how to fetch deleted row oracle 11g By: rahuljadhav177@gmail.com on Tue, 22 December 2015	15	2483	Thu, 24 December 2015 05:24 By: cookiemonster
Generate GUID other than sys_GUID() (merged 3) Oracle 12c By: fabi88 on Tue, 22 December 2015	27	5597	Wed, 23 December 2015 23:15 By: fabi88
TO_NUMBER Doesn't Support These Elements: RN, rn, TM, and V ? Oracle Database 11g, Unix By: kittokevin on Tue, 22 December 2015	2	1502	Tue, 22 December 2015 21:52 By: Solomon Yakobson
Parameterized One-Time-Only procedure.... By: mokarem on Tue, 15 December 2015	18	2685	Tue, 22 December 2015 17:27 By: Solomon Yakobson
Help with oracle query to manipulate dates By: nsk78 on Tue, 22 December 2015	1	1098	Tue, 22 December 2015 08:29 By: BlackSwan
help to correct syntax error oracle 12c By: vs140580 on Mon, 21 December 2015	11	1795	Mon, 21 December 2015 22:47 By: BlackSwan