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
Remove null records from collection 11.2.0.4.0 By: pointers on Thu, 19 January 2017	1	3334	Thu, 19 January 2017 09:59 By: Michel Cadot
Collections Oracle 11.2.0.0 By: pointers on Thu, 19 January 2017	9	4283	Thu, 19 January 2017 08:30 By: BlackSwan
unable to get data from V$SESSION table By: asliyanage on Wed, 18 January 2017	4	11347	Thu, 19 January 2017 06:39 By: EdStevens
Help with REGEXP_SUBSTR Oracle 10g By: adfnewbie on Tue, 17 January 2017	6	5113	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	5388	Mon, 16 January 2017 09:14 By: Roachcoach
AUDSID temporary not found 12C (PDB) By: Gogetter on Mon, 16 January 2017	0	2358	Mon, 16 January 2017 04:36 By: Gogetter
Regarding Hints Oracle 11g, Windows By: ninan on Thu, 12 January 2017	10	5262	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	15213	Fri, 13 January 2017 22:59 By: BlackSwan
ORA-14155 oracle 10g By: mary_xXx on Wed, 09 July 2008	5	22031	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	3628	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	4789	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	3263	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	8535	Thu, 12 January 2017 07:23 By: Irish88
Recursive SQL Insert Oracle 11g By: Danny Freeman on Tue, 10 January 2017	2	3070	Tue, 10 January 2017 14:05 By: Barbara Boehmer
dependency question By: desmond30 on Tue, 10 January 2017	1	2480	Tue, 10 January 2017 13:52 By: Michel Cadot
separate 2 columns into 2 rows By: wtolentino on Wed, 28 December 2016	8	4652	Tue, 10 January 2017 03:42 By: cookiemonster
GROUP BY COST CENTER By: vharish006 on Mon, 09 January 2017	2	2701	Mon, 09 January 2017 11:50 By: Michel Cadot
check format 10g By: arifmd1705 on Sun, 08 January 2017	6	3800	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	3140	Sun, 08 January 2017 11:32 By: Michel Cadot
execute immediate 11gR2, windows 7 By: deep_saha on Sat, 07 January 2017	6	4083	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	2915	Fri, 06 January 2017 13:22 By: Bill B
Shrink space Oracle 11g/12c By: srinivas.k2005 on Fri, 06 January 2017	3	3171	Fri, 06 January 2017 10:10 By: srinivas.k2005
email validation oracle 10g windowsXP By: varosh81 on Fri, 28 March 2008	11	17237	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	3159	Thu, 05 January 2017 07:31 By: Michel Cadot
EXTERNAL TABLE CREATION ERROR By: vharish006 on Tue, 03 January 2017	7	9541	Wed, 04 January 2017 16:38 By: Barbara Boehmer
JSON_TABLE concurrent access issue Oracle 12C By: VeeS on Wed, 04 January 2017	1	4919	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	5952	Tue, 03 January 2017 12:52 By: Solomon Yakobson
Partitions oracle 12c By: bheemasql on Sun, 01 January 2017	4	3779	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	9689	Mon, 02 January 2017 23:20 By: grpatwari
selecting the columns dynamically 11.2.0.4 By: grpatwari on Mon, 02 January 2017	5	3701	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	18191	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	8687	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	4945	Thu, 29 December 2016 13:26 By: Bill B
query next value oracle 11g By: oracle_coorgi on Thu, 29 December 2016	8	4258	Thu, 29 December 2016 11:40 By: oracle_coorgi
Oracle sql id count Oracle, 11G By: Aleks21 on Thu, 29 December 2016	3	3417	Thu, 29 December 2016 09:26 By: Michel Cadot
display all numbers with like 11g By: glmjoy on Wed, 28 December 2016	4	4214	Wed, 28 December 2016 08:12 By: Michel Cadot
ROLLBACK usingTRUNCATE Oracle 11.2.0.3 By: pointers on Mon, 26 December 2016	5	3770	Tue, 27 December 2016 10:01 By: Michel Cadot
ORA-01426 "Numeric Overflow" By: challa384 on Tue, 27 December 2016	5	10424	Tue, 27 December 2016 07:32 By: Bill B
How to bypass the selective rows from SQL Analytic function Oracle 11.2.0.1.0 By: jimit_shaili on Fri, 23 December 2016	4	4102	Sat, 24 December 2016 08:41 By: Solomon Yakobson
Order By Taking time Oracle By: mskphani on Thu, 22 December 2016	4	3493	Fri, 23 December 2016 11:19 By: Michel Cadot