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
  Heterogeneous DB error propagating past WHEN OTHERS
Oracle 11gR2, SQL Server 2008
By: EricS13 on Mon, 09 October 2017
6 122507 Tue, 10 October 2017 09:28
By: cookiemonster
  row-to-row navigation query
By: martjosh on Thu, 05 October 2017
11 312427 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 161432 Tue, 10 October 2017 09:17
By: quirks
  Left Outer Join with SubQuery
By: suji6281 on Fri, 22 September 2017
4 27046 Tue, 10 October 2017 07:12
By: suji6281
  Finding characters other than keyboard character
Oracle 10g
By: sss111ind on Wed, 20 September 2017
6 69898 Mon, 09 October 2017 05:38
By: sss111ind
  SQL Query Help
SQL Developer
By: reddy0422 on Sun, 08 October 2017
1 136110 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 72092 Thu, 05 October 2017 16:30
By: orabert
  Tablespaces for Index Partitions and Subpartitions
By: scottwmackey on Wed, 04 October 2017
11 595983 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 52253 Wed, 04 October 2017 08:37
By: joy_division
  Help in SQL query
11g
By: dr46014 on Wed, 04 October 2017
5 73354 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 212304 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 215413 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 45346 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 52110 Thu, 28 September 2017 19:11
By: Solomon Yakobson
  Cuimulative totals
12c
By: m.abdulhaq on Thu, 28 September 2017
3 53274 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 103866 Wed, 27 September 2017 03:27
By: cookiemonster
  sub totals in sql
12c
By: m.abdulhaq on Sun, 24 September 2017
4 163111 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 503788 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 72739 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 60614 Thu, 21 September 2017 09:16
By: manikandan23
  Update Logic
Oracle,12c,NT
By: pstanand on Wed, 20 September 2017
7 4960 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 35075 Wed, 20 September 2017 11:47
By: grpatwari
  compare 2 collections data
Oracle 12c
By: sss111ind on Wed, 20 September 2017
5 71269 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 93119 Tue, 19 September 2017 15:58
By: philipebe
  split name
By: suji6281 on Fri, 15 September 2017
10 107165 Tue, 19 September 2017 08:43
By: suji6281
  finding status
12c
By: m.abdulhaq on Fri, 15 September 2017
2 22230 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 54175 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 102356 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 14101 Mon, 18 September 2017 09:11
By: sss111ind
  Large volume data compare - NEED HELP
Oracle 11
By: Member2014 on Wed, 13 September 2017
12 54428 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 6658 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 54575 Thu, 14 September 2017 09:39
By: JPBoileau
  UTL_FILE.PUT. Need help to handle the line with more than 32767 characters
Oracle, 11.2, Windows
By: sayampub on Sun, 10 September 2017
6 162983 Wed, 13 September 2017 17:26
By: Solomon Yakobson
  Finding Date overlap
Oracle 11 g
By: samiran_cts on Mon, 11 September 2017
7 29922 Wed, 13 September 2017 02:17
By: quirks
  UNIQUE CONSTRAINT FOR EXISTING COLUMN WITH DUPLICATE RECORDS
By: Poovaraghavan on Fri, 08 September 2017
12 133205 Mon, 11 September 2017 05:42
By: Roachcoach
  left outer join of 3 tables
By: suji6281 on Wed, 06 September 2017
9 53631 Fri, 08 September 2017 07:22
By: suji6281
  Why some of my SQL are run slower in Oracle In-memory than it was before?
By: Peter TL Wong on Wed, 06 September 2017
6 91724 Fri, 08 September 2017 02:02
By: John Watson
  updated column on the same table automatically
11.2.0.4.0 - 64bit Production
By: mist598 on Mon, 04 September 2017
8 33021 Thu, 07 September 2017 11:58
By: Bill B
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 24870 Wed, 06 September 2017 05:17
By: quirks
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 10844 Wed, 06 September 2017 04:51
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: Fri May 17 03:14:16 CDT 2024