Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  unable to get data from V$SESSION table
By: asliyanage on Wed, 18 January 2017
4 994 Thu, 19 January 2017 06:39
By: EdStevens
  Help with REGEXP_SUBSTR
Oracle 10g
By: adfnewbie on Tue, 17 January 2017
6 1305 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 1420 Mon, 16 January 2017 09:14
By: Roachcoach
  AUDSID temporary not found
12C (PDB)
By: Gogetter on Mon, 16 January 2017
0 685 Mon, 16 January 2017 04:36
By: Gogetter
  Regarding Hints
Oracle 11g, Windows
By: ninan on Thu, 12 January 2017
10 1356 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 2689 Fri, 13 January 2017 22:59
By: BlackSwan
  ORA-14155
oracle 10g
By: mary_xXx on Wed, 09 July 2008
5 12186 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 877 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 1263 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 804 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 1671 Thu, 12 January 2017 07:23
By: Irish88
  Recursive SQL Insert
Oracle 11g
By: Danny Freeman on Tue, 10 January 2017
2 698 Tue, 10 January 2017 14:05
By: Barbara Boehmer
  dependency question
By: desmond30 on Tue, 10 January 2017
1 630 Tue, 10 January 2017 13:52
By: Michel Cadot
  separate 2 columns into 2 rows
By: wtolentino on Wed, 28 December 2016
8 1530 Tue, 10 January 2017 03:42
By: cookiemonster
  GROUP BY COST CENTER
By: vharish006 on Mon, 09 January 2017
2 820 Mon, 09 January 2017 11:50
By: Michel Cadot
  check format
10g
By: arifmd1705 on Sun, 08 January 2017
6 918 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 794 Sun, 08 January 2017 11:32
By: Michel Cadot
  execute immediate
11gR2, windows 7
By: deep_saha on Sat, 07 January 2017
6 966 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 1049 Fri, 06 January 2017 13:22
By: Bill B
  Shrink space
Oracle 11g/12c
By: srinivas.k2005 on Fri, 06 January 2017
3 912 Fri, 06 January 2017 10:10
By: srinivas.k2005
  email validation
oracle 10g windowsXP
By: varosh81 on Fri, 28 March 2008
11 9265 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 710 Thu, 05 January 2017 07:31
By: Michel Cadot
  EXTERNAL TABLE CREATION ERROR
By: vharish006 on Tue, 03 January 2017
7 1268 Wed, 04 January 2017 16:38
By: Barbara Boehmer
  JSON_TABLE concurrent access issue
Oracle 12C
By: VeeS on Wed, 04 January 2017
1 958 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 1112 Tue, 03 January 2017 12:52
By: Solomon Yakobson
  Partitions
oracle 12c
By: bheemasql on Sun, 01 January 2017
4 1119 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 2057 Mon, 02 January 2017 23:20
By: grpatwari
  selecting the columns dynamically
11.2.0.4
By: grpatwari on Mon, 02 January 2017
5 983 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 6154 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 1758 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 1084 Thu, 29 December 2016 13:26
By: Bill B
  query next value
oracle 11g
By: oracle_coorgi on Thu, 29 December 2016
8 1005 Thu, 29 December 2016 11:40
By: oracle_coorgi
  Oracle sql id count
Oracle, 11G
By: Aleks21 on Thu, 29 December 2016
3 741 Thu, 29 December 2016 09:26
By: Michel Cadot
  display all numbers with like
11g
By: glmjoy on Wed, 28 December 2016
4 826 Wed, 28 December 2016 08:12
By: Michel Cadot
  ROLLBACK usingTRUNCATE
Oracle 11.2.0.3
By: pointers on Mon, 26 December 2016
5 1011 Tue, 27 December 2016 10:01
By: Michel Cadot
icon5.gif ORA-01426 "Numeric Overflow"
By: challa384 on Tue, 27 December 2016
5 1277 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 1084 Sat, 24 December 2016 08:41
By: Solomon Yakobson
  Order By Taking time
Oracle
By: mskphani on Thu, 22 December 2016
4 1163 Fri, 23 December 2016 11:19
By: Michel Cadot
  DB-LINK to mysql
Oracle Database 11g Release 11.2.0.1.0
By: iliyan_84@abv.bg on Wed, 21 December 2016
20 2494 Fri, 23 December 2016 07:25
By: iliyan_84@abv.bg
  Quantity allocation to discount slabs
Oracle 11.2.0.1.0
By: jimit_shaili on Mon, 19 December 2016
4 1162 Fri, 23 December 2016 03:07
By: jimit_shaili
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Tue Jun 19 00:22:30 CDT 2018