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
Effective Date/Min Eff Seq subquery issues PS Student Administration By: Lasmith76 on Sat, 21 January 2017	4	2877	Sun, 22 January 2017 10:10 By: Lasmith76
How to create an object table By: janeya3110@gmail.com on Fri, 20 January 2017	5	2565	Sat, 21 January 2017 01:16 By: Michel Cadot
Remove null records from collection 11.2.0.4.0 By: pointers on Thu, 19 January 2017	1	2487	Thu, 19 January 2017 09:59 By: Michel Cadot
Collections Oracle 11.2.0.0 By: pointers on Thu, 19 January 2017	9	2701	Thu, 19 January 2017 08:30 By: BlackSwan
unable to get data from V$SESSION table By: asliyanage on Wed, 18 January 2017	4	9187	Thu, 19 January 2017 06:39 By: EdStevens
Help with REGEXP_SUBSTR Oracle 10g By: adfnewbie on Tue, 17 January 2017	6	3728	Tue, 17 January 2017 09:34 By: Bill B
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2 Enterprise Edition 10.2.0.4.0 - 64bit, Windows Server 2008 By: arfan_alam on Mon, 16 January 2017	9	3744	Mon, 16 January 2017 09:14 By: Roachcoach
AUDSID temporary not found 12C (PDB) By: Gogetter on Mon, 16 January 2017	0	1729	Mon, 16 January 2017 04:36 By: Gogetter
Regarding Hints Oracle 11g, Windows By: ninan on Thu, 12 January 2017	10	3376	Mon, 16 January 2017 03:44 By: cookiemonster
PL/SQL table :: ORA-00902: invalid datatype Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: abhi_orcl on Fri, 13 January 2017	10	11709	Fri, 13 January 2017 22:59 By: BlackSwan
ORA-14155 oracle 10g By: mary_xXx on Wed, 09 July 2008	5	19950	Thu, 12 January 2017 20:34 By: arddy123
Help to write the SQL query to Oracle DEveloper 11G By: nirmeshvats on Thu, 12 January 2017	3	2419	Thu, 12 January 2017 12:52 By: John Watson
DBA_VIEWS giving ORA-00942 Error Oracle Database 12c 12.1.0.2.0 - 64bit Production By: abhi_orcl on Mon, 09 January 2017	3	3661	Thu, 12 January 2017 08:01 By: Bill B
add a sequential number to a query sql By: sanjuchand on Thu, 12 January 2017	3	2282	Thu, 12 January 2017 07:57 By: Bill B
Compiling in Debug Mode Oracle 11g / SQL Developer By: Irish88 on Tue, 10 January 2017	19	5789	Thu, 12 January 2017 07:23 By: Irish88
Recursive SQL Insert Oracle 11g By: Danny Freeman on Tue, 10 January 2017	2	1900	Tue, 10 January 2017 14:05 By: Barbara Boehmer
dependency question By: desmond30 on Tue, 10 January 2017	1	1784	Tue, 10 January 2017 13:52 By: Michel Cadot
separate 2 columns into 2 rows By: wtolentino on Wed, 28 December 2016	8	3326	Tue, 10 January 2017 03:42 By: cookiemonster
GROUP BY COST CENTER By: vharish006 on Mon, 09 January 2017	2	1998	Mon, 09 January 2017 11:50 By: Michel Cadot
check format 10g By: arifmd1705 on Sun, 08 January 2017	6	2586	Sun, 08 January 2017 12:33 By: arifmd1705
Getting ORA-01422: exact fetch returns more than requested number of rows By: msyogi on Sun, 08 January 2017	2	2231	Sun, 08 January 2017 11:32 By: Michel Cadot
execute immediate 11gR2, windows 7 By: deep_saha on Sat, 07 January 2017	6	2807	Sun, 08 January 2017 02:37 By: Michel Cadot
How to Move fast the data from one database to another database ? By: sivaparam on Fri, 06 January 2017	2	2121	Fri, 06 January 2017 13:22 By: Bill B
Shrink space Oracle 11g/12c By: srinivas.k2005 on Fri, 06 January 2017	3	2236	Fri, 06 January 2017 10:10 By: srinivas.k2005
email validation oracle 10g windowsXP By: varosh81 on Fri, 28 March 2008	11	14197	Thu, 05 January 2017 08:23 By: cookiemonster
Collections - Nested Tables and VARRAY Oracle 11.2.0.3 By: pointers on Thu, 05 January 2017	3	2031	Thu, 05 January 2017 07:31 By: Michel Cadot
EXTERNAL TABLE CREATION ERROR By: vharish006 on Tue, 03 January 2017	7	7020	Wed, 04 January 2017 16:38 By: Barbara Boehmer
JSON_TABLE concurrent access issue Oracle 12C By: VeeS on Wed, 04 January 2017	1	3879	Wed, 04 January 2017 14:41 By: BlackSwan
SYSDATE - 1 'MM' for JAN showing 0 instead of 12 Oracle By: aceboku on Tue, 03 January 2017	8	3582	Tue, 03 January 2017 12:52 By: Solomon Yakobson
Partitions oracle 12c By: bheemasql on Sun, 01 January 2017	4	2604	Tue, 03 January 2017 09:49 By: Bill B
Insert the data into dynamically created table (2 threads merged by bb) 11.2.0.4 By: grpatwari on Thu, 18 August 2016	15	7203	Mon, 02 January 2017 23:20 By: grpatwari
selecting the columns dynamically 11.2.0.4 By: grpatwari on Mon, 02 January 2017	5	2349	Mon, 02 January 2017 06:16 By: Michel Cadot
Problem accessing external tables over network Oracle 10g Windows 2003 server Windows XP By: Iain on Mon, 16 June 2008	14	14642	Fri, 30 December 2016 00:51 By: rizuane
Calculate percentage based on month Oracle 11.2.0.3.0 By: amarjadhav on Tue, 27 December 2016	9	6513	Thu, 29 December 2016 13:56 By: Barbara Boehmer
Query table names from dba_tables Oracle Database 12c 12.1.0.2.0 - 64bit Production By: abhi_orcl on Thu, 29 December 2016	7	3260	Thu, 29 December 2016 13:26 By: Bill B
query next value oracle 11g By: oracle_coorgi on Thu, 29 December 2016	8	2673	Thu, 29 December 2016 11:40 By: oracle_coorgi
Oracle sql id count Oracle, 11G By: Aleks21 on Thu, 29 December 2016	3	1945	Thu, 29 December 2016 09:26 By: Michel Cadot
display all numbers with like 11g By: glmjoy on Wed, 28 December 2016	4	2310	Wed, 28 December 2016 08:12 By: Michel Cadot
ROLLBACK usingTRUNCATE Oracle 11.2.0.3 By: pointers on Mon, 26 December 2016	5	2492	Tue, 27 December 2016 10:01 By: Michel Cadot
ORA-01426 "Numeric Overflow" By: challa384 on Tue, 27 December 2016	5	8374	Tue, 27 December 2016 07:32 By: Bill B