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
  REPLACE Function
Oracle,12c,Unix
By: pstanand on Fri, 20 October 2017
6 86030 Fri, 20 October 2017 08:37
By: pstanand
  DBTime Zone&Off Set
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Revathi.orafaq on Wed, 18 October 2017
2 39464 Fri, 20 October 2017 00:46
By: Revathi.orafaq
  Restrictions on DDL-triggers in PL/SQL
Oracle XE 11.2.0.2 on Windows 10
By: Alien on Wed, 18 October 2017
3 138682 Thu, 19 October 2017 08:06
By: Alien
  Passing UDT as a SP parameter
11.0.2.10
By: OraFerro on Mon, 16 October 2017
4 57440 Tue, 17 October 2017 03:26
By: OraFerro
  How to extract out huge result set in xml format as .xml file
12.1.0.2
By: philipebe on Mon, 16 October 2017
1 62069 Mon, 16 October 2017 15:01
By: BlackSwan
  Composite Partitioning
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Revathi.orafaq on Mon, 16 October 2017
2 47542 Mon, 16 October 2017 07:02
By: Revathi.orafaq
  Combination of more/less and brackets cause TRUE or FALSE (merged 2)
Oracle DB 12c
By: isri on Thu, 12 October 2017
3 71058 Thu, 12 October 2017 04:57
By: isri
  returning collection from a loop and bulk collect
Oracle 11
By: roger6701 on Tue, 10 October 2017
10 72260 Tue, 10 October 2017 16:00
By: roger6701
  Heterogeneous DB error propagating past WHEN OTHERS
Oracle 11gR2, SQL Server 2008
By: EricS13 on Mon, 09 October 2017
6 119637 Tue, 10 October 2017 09:28
By: cookiemonster
  row-to-row navigation query
By: martjosh on Thu, 05 October 2017
11 63628 Tue, 10 October 2017 09:26
By: quirks
  Show multiple count in one result set
Oracle 12c
By: fabi88 on Mon, 09 October 2017
6 160065 Tue, 10 October 2017 09:17
By: quirks
  Left Outer Join with SubQuery
By: suji6281 on Fri, 22 September 2017
4 21703 Tue, 10 October 2017 07:12
By: suji6281
  Finding characters other than keyboard character
Oracle 10g
By: sss111ind on Wed, 20 September 2017
6 68658 Mon, 09 October 2017 05:38
By: sss111ind
  SQL Query Help
SQL Developer
By: reddy0422 on Sun, 08 October 2017
1 134988 Sun, 08 October 2017 08:41
By: BlackSwan
  Using WITH clause values as parameters in a TABLE function
Oracle 11.2.0.4 on Windows 7 64bit
By: orabert on Thu, 05 October 2017
2 28716 Thu, 05 October 2017 16:30
By: orabert
  Tablespaces for Index Partitions and Subpartitions
By: scottwmackey on Wed, 04 October 2017
11 74194 Thu, 05 October 2017 14:28
By: Alien
  Sending Single email from database in case of multiple updates
Oracle 11gR2
By: oracbeg on Wed, 04 October 2017
3 50967 Wed, 04 October 2017 08:37
By: joy_division
  Help in SQL query
11g
By: dr46014 on Wed, 04 October 2017
5 72007 Wed, 04 October 2017 06:54
By: EdStevens
  how to run SQL Developer in debug
12.1.0.2.0
By: jokrasa on Mon, 02 October 2017
3 207817 Mon, 02 October 2017 15:56
By: jokrasa
  Converting SYS_REFCURSOR to xml
Oracle 12c
By: sampathkore4444@gmail.com on Wed, 27 September 2017
1 212816 Sat, 30 September 2017 23:48
By: Barbara Boehmer
  Restrict the other session for tables
11.2.0.4
By: grpatwari on Wed, 13 September 2017
22 41017 Thu, 28 September 2017 23:20
By: grpatwari
  regexp_replace append 0 to single digit date,month,hour,minute,second
By: manubatham20 on Wed, 27 September 2017
5 50275 Thu, 28 September 2017 19:11
By: Solomon Yakobson
  Cuimulative totals
12c
By: m.abdulhaq on Thu, 28 September 2017
3 51940 Thu, 28 September 2017 08:28
By: m.abdulhaq
  Multiple record insert using PLSQL
11.0.2.10
By: OraFerro on Wed, 27 September 2017
1 102407 Wed, 27 September 2017 03:27
By: cookiemonster
  sub totals in sql
12c
By: m.abdulhaq on Sun, 24 September 2017
4 161504 Sun, 24 September 2017 10:19
By: m.abdulhaq
  Adding column to the table which have the huge data
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production ( 1 2)
By: Revathi.orafaq on Mon, 11 September 2017
44 499306 Fri, 22 September 2017 07:51
By: Revathi.orafaq
  PL/SQl query to build a list of interval days
11.2.0.4
By: veepee on Fri, 15 September 2017
9 71014 Fri, 22 September 2017 02:41
By: quirks
  Need Date format in YYYY-MM-DDThh:mm:ss.sTZD (eg 1997-07-16T19:20:30.45+01:00)
Oracle 11g
By: manikandan23 on Wed, 20 September 2017
3 55196 Thu, 21 September 2017 09:16
By: manikandan23
  Update Logic
Oracle,12c,NT
By: pstanand on Wed, 20 September 2017
7 3293 Thu, 21 September 2017 06:45
By: pstanand
  ORA-06530: Reference to uninitialized composite
11.2.0.4.0
By: grpatwari on Wed, 20 September 2017
3 33476 Wed, 20 September 2017 11:47
By: grpatwari
  compare 2 collections data
Oracle 12c
By: sss111ind on Wed, 20 September 2017
5 67678 Wed, 20 September 2017 07:27
By: Solomon Yakobson
  extract numbers from a varchar2 upto non-numeric
12.1.0.2.0
By: philipebe on Tue, 19 September 2017
2 92034 Tue, 19 September 2017 15:58
By: philipebe
  split name
By: suji6281 on Fri, 15 September 2017
10 104085 Tue, 19 September 2017 08:43
By: suji6281
  finding status
12c
By: m.abdulhaq on Fri, 15 September 2017
2 21214 Tue, 19 September 2017 05:51
By: quirks
  How to verify if string contains unwanted character
Oracle Db 11g and later
By: ator on Wed, 06 September 2017
6 47892 Tue, 19 September 2017 05:08
By: quirks
  How to insert HINDI word in ORACLE
ORACLE 11G
By: sss111ind on Mon, 18 September 2017
4 100517 Tue, 19 September 2017 03:29
By: cookiemonster
  LPX-00230: invalid character 0 (U+0000) found in a Name or Nmtoken
Oracle 10g
By: sss111ind on Mon, 07 August 2017
2 11545 Mon, 18 September 2017 09:11
By: sss111ind
  Large volume data compare - NEED HELP
Oracle 11
By: Member2014 on Wed, 13 September 2017
12 52806 Fri, 15 September 2017 15:41
By: Member2014
  Adding ax extra column to the existing constraint
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Revathi.orafaq on Fri, 15 September 2017
2 5401 Fri, 15 September 2017 03:54
By: Revathi.orafaq
  wirting automatically multi files by utl_file.fopen
oracle database, 11g, window
By: a76014 on Sat, 09 September 2017
2 53173 Thu, 14 September 2017 09:39
By: JPBoileau
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: Sat Nov 16 18:00:46 CST 2019