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
  Sending Single email from database in case of multiple updates
Oracle 11gR2
By: oracbeg on Wed, 04 October 2017
3 50941 Wed, 04 October 2017 08:37
By: joy_division
  Help in SQL query
11g
By: dr46014 on Wed, 04 October 2017
5 71963 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 207668 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 212741 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 40963 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 50243 Thu, 28 September 2017 19:11
By: Solomon Yakobson
  Cuimulative totals
12c
By: m.abdulhaq on Thu, 28 September 2017
3 51917 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 102369 Wed, 27 September 2017 03:27
By: cookiemonster
  sub totals in sql
12c
By: m.abdulhaq on Sun, 24 September 2017
4 161486 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 499236 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 70940 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 55068 Thu, 21 September 2017 09:16
By: manikandan23
  Update Logic
Oracle,12c,NT
By: pstanand on Wed, 20 September 2017
7 3245 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 33406 Wed, 20 September 2017 11:47
By: grpatwari
  compare 2 collections data
Oracle 12c
By: sss111ind on Wed, 20 September 2017
5 67525 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 91986 Tue, 19 September 2017 15:58
By: philipebe
  split name
By: suji6281 on Fri, 15 September 2017
10 104024 Tue, 19 September 2017 08:43
By: suji6281
  finding status
12c
By: m.abdulhaq on Fri, 15 September 2017
2 21161 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 47732 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 100401 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 11449 Mon, 18 September 2017 09:11
By: sss111ind
  Large volume data compare - NEED HELP
Oracle 11
By: Member2014 on Wed, 13 September 2017
12 52746 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 5355 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 53091 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 160330 Wed, 13 September 2017 17:26
By: Solomon Yakobson
  Finding Date overlap
Oracle 11 g
By: samiran_cts on Mon, 11 September 2017
7 28491 Wed, 13 September 2017 02:17
By: quirks
  UNIQUE CONSTRAINT FOR EXISTING COLUMN WITH DUPLICATE RECORDS
By: Poovaraghavan on Fri, 08 September 2017
12 130460 Mon, 11 September 2017 05:42
By: Roachcoach
  left outer join of 3 tables
By: suji6281 on Wed, 06 September 2017
9 50569 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 89717 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 31289 Thu, 07 September 2017 11:58
By: Bill B
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 23298 Wed, 06 September 2017 05:17
By: quirks
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 9372 Wed, 06 September 2017 04:51
By: cookiemonster
  how to extract data from oracle table having space in column name using vba code?
By: oracbeg on Tue, 05 September 2017
4 68151 Tue, 05 September 2017 09:01
By: Bill B
  PLSQL Procedure to Grant Privs on Schema Objects
Oracle Database 12.1.0.2 on Linux 6.9
By: Lucky A on Fri, 01 September 2017
7 74153 Tue, 05 September 2017 04:12
By: cookiemonster
  Select u'' from dual; What does u mean? in this sql.
Oracle 11G, 2.0.1
By: chrisindya on Fri, 01 September 2017
2 24389 Tue, 05 September 2017 04:11
By: chrisindya
  the records with common cust_id should not be shown.
By: adil shakeel on Mon, 28 August 2017
12 21861 Mon, 04 September 2017 02:26
By: quirks
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 26439 Mon, 04 September 2017 02:00
By: quirks
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 12464 Mon, 04 September 2017 01:37
By: quirks
  Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g
Oracle 12.1.
By: rkrishna on Sun, 27 August 2017
10 18546 Sun, 03 September 2017 06:38
By: John Watson
  Unexpected weird result A+A' != U
10.2.0.1.0
By: bluetooth420 on Wed, 30 August 2017
7 76359 Fri, 01 September 2017 02:24
By: Roachcoach
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: Wed Oct 16 05:01:32 CDT 2019