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
  Function To Reverese The Phone Number
By: Hemanth319 on Sun, 05 February 2017
5 849 Mon, 06 February 2017 14:54
By: Bill B
  Writing multiple Files using UTL_FILE
11g, Windows XP
By: siva27 on Mon, 06 February 2017
6 726 Mon, 06 February 2017 08:00
By: Michel Cadot
  Performance tuning in delete operation
Oracle 11g
By: raj85844 on Tue, 31 January 2017
5 907 Fri, 03 February 2017 04:03
By: John Watson
  order of operations in the below statements
sql developer
By: M123 on Thu, 02 February 2017
3 740 Fri, 03 February 2017 03:25
By: cookiemonster
  constraint error
10g, win8.1,
By: rzkhan on Tue, 31 January 2017
28 1775 Wed, 01 February 2017 10:28
By: Michel Cadot
  Help with update statement
Oracle 11g, 2, Solaris 11
By: apenkov on Tue, 31 January 2017
6 763 Wed, 01 February 2017 08:00
By: Bill B
  Procedure out of statements
By: m_r_a on Wed, 01 February 2017
16 1074 Wed, 01 February 2017 03:29
By: cookiemonster
  ORA-01722 for bind variable in dbms_sql
Oracle 10g
By: myadi26 on Sun, 29 January 2017
6 819 Sun, 29 January 2017 07:55
By: Michel Cadot
  cursor leak and open cursors
Oracle12c
By: shrinika on Thu, 26 January 2017
6 796 Fri, 27 January 2017 14:39
By: shrinika
  JSON Parsing
Linux, Oracle 11.2.0.3.0
By: gopieee16 on Tue, 24 January 2017
4 1143 Fri, 27 January 2017 04:31
By: Michel Cadot
  Doubt in SYS_CONTEXT
By: gajini on Tue, 24 January 2017
6 837 Fri, 27 January 2017 03:24
By: cookiemonster
  scrambling the data for a column in a tables
oracle 11g version 2
By: raj85844 on Mon, 09 January 2017
15 2940 Tue, 24 January 2017 13:28
By: Bill B
  SQL Execution Plan
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: trivendra on Mon, 23 January 2017
4 846 Mon, 23 January 2017 13:18
By: trivendra
  Edition Based Redefinition - Triggers on Editioning Views
Oracle Database 11g Enterprise Edition 11.2.0.4.0 64 Bit Production, Linux
By: fixxxer on Wed, 18 January 2017
7 1136 Mon, 23 January 2017 04:08
By: Michel Cadot
  Oracle Outer join Operator(+) with operand of OR or IN
Oracle, 11g, Windows 7
By: azamkhan on Mon, 23 January 2017
1 539 Mon, 23 January 2017 00:22
By: Michel Cadot
  Effective Date/Min Eff Seq subquery issues
PS Student Administration
By: Lasmith76 on Sat, 21 January 2017
4 772 Sun, 22 January 2017 10:10
By: Lasmith76
  How to create an object table
By: janeya3110@gmail.com on Fri, 20 January 2017
5 981 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 758 Thu, 19 January 2017 09:59
By: Michel Cadot
  Collections
Oracle 11.2.0.0
By: pointers on Thu, 19 January 2017
9 1000 Thu, 19 January 2017 08:30
By: BlackSwan
  unable to get data from V$SESSION table
By: asliyanage on Wed, 18 January 2017
4 952 Thu, 19 January 2017 06:39
By: EdStevens
  Help with REGEXP_SUBSTR
Oracle 10g
By: adfnewbie on Tue, 17 January 2017
6 1239 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 1336 Mon, 16 January 2017 09:14
By: Roachcoach
  AUDSID temporary not found
12C (PDB)
By: Gogetter on Mon, 16 January 2017
0 663 Mon, 16 January 2017 04:36
By: Gogetter
  Regarding Hints
Oracle 11g, Windows
By: ninan on Thu, 12 January 2017
10 1289 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 2500 Fri, 13 January 2017 22:59
By: BlackSwan
  ORA-14155
oracle 10g
By: mary_xXx on Wed, 09 July 2008
5 12056 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 834 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 1207 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 767 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 1513 Thu, 12 January 2017 07:23
By: Irish88
  Recursive SQL Insert
Oracle 11g
By: Danny Freeman on Tue, 10 January 2017
2 668 Tue, 10 January 2017 14:05
By: Barbara Boehmer
  dependency question
By: desmond30 on Tue, 10 January 2017
1 604 Tue, 10 January 2017 13:52
By: Michel Cadot
  separate 2 columns into 2 rows
By: wtolentino on Wed, 28 December 2016
8 1450 Tue, 10 January 2017 03:42
By: cookiemonster
  GROUP BY COST CENTER
By: vharish006 on Mon, 09 January 2017
2 785 Mon, 09 January 2017 11:50
By: Michel Cadot
  check format
10g
By: arifmd1705 on Sun, 08 January 2017
6 863 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 762 Sun, 08 January 2017 11:32
By: Michel Cadot
  execute immediate
11gR2, windows 7
By: deep_saha on Sat, 07 January 2017
6 909 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 1021 Fri, 06 January 2017 13:22
By: Bill B
  Shrink space
Oracle 11g/12c
By: srinivas.k2005 on Fri, 06 January 2017
3 875 Fri, 06 January 2017 10:10
By: srinivas.k2005
  email validation
oracle 10g windowsXP
By: varosh81 on Fri, 28 March 2008
11 9126 Thu, 05 January 2017 08:23
By: cookiemonster
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: Sun May 27 20:30:32 CDT 2018