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
  Help in SQL query
11g
By: dr46014 on Wed, 04 October 2017
5 37094 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 107829 Mon, 02 October 2017 15:56
By: jokrasa
  Cuimulative totals
12c
By: m.abdulhaq on Thu, 28 September 2017
3 26382 Thu, 28 September 2017 08:28
By: m.abdulhaq
  Converting SYS_REFCURSOR to xml
Oracle 12c
By: sampathkore4444@gmail.com on Wed, 27 September 2017
1 112343 Sat, 30 September 2017 23:48
By: Barbara Boehmer
  regexp_replace append 0 to single digit date,month,hour,minute,second
By: manubatham20 on Wed, 27 September 2017
5 26889 Thu, 28 September 2017 19:11
By: Solomon Yakobson
  Multiple record insert using PLSQL
11.0.2.10
By: OraFerro on Wed, 27 September 2017
1 52911 Wed, 27 September 2017 03:27
By: cookiemonster
  Left Outer Join with SubQuery
By: suji6281 on Fri, 22 September 2017
4 10590 Tue, 10 October 2017 07:12
By: suji6281
  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 28159 Thu, 21 September 2017 09:16
By: manikandan23
  ORA-06530: Reference to uninitialized composite
11.2.0.4.0
By: grpatwari on Wed, 20 September 2017
3 17055 Wed, 20 September 2017 11:47
By: grpatwari
  Update Logic
Oracle,12c,NT
By: pstanand on Wed, 20 September 2017
7 1046 Thu, 21 September 2017 06:45
By: pstanand
  Finding characters other than keyboard character
Oracle 10g
By: sss111ind on Wed, 20 September 2017
6 35399 Mon, 09 October 2017 05:38
By: sss111ind
  sub totals in sql
12c
By: m.abdulhaq on Sun, 24 September 2017
4 90600 Sun, 24 September 2017 10:19
By: m.abdulhaq
  extract numbers from a varchar2 upto non-numeric
12.1.0.2.0
By: philipebe on Tue, 19 September 2017
2 48249 Tue, 19 September 2017 15:58
By: philipebe
  compare 2 collections data
Oracle 12c
By: sss111ind on Wed, 20 September 2017
5 34867 Wed, 20 September 2017 07:27
By: Solomon Yakobson
  How to insert HINDI word in ORACLE
ORACLE 11G
By: sss111ind on Mon, 18 September 2017
4 52016 Tue, 19 September 2017 03:29
By: cookiemonster
  split name
By: suji6281 on Fri, 15 September 2017
10 62898 Tue, 19 September 2017 08:43
By: suji6281
  PL/SQl query to build a list of interval days
11.2.0.4
By: veepee on Fri, 15 September 2017
9 38112 Fri, 22 September 2017 02:41
By: quirks
  finding status
12c
By: m.abdulhaq on Fri, 15 September 2017
2 10773 Tue, 19 September 2017 05:51
By: quirks
  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 2340 Fri, 15 September 2017 03:54
By: Revathi.orafaq
  Large volume data compare - NEED HELP
Oracle 11
By: Member2014 on Wed, 13 September 2017
12 33667 Fri, 15 September 2017 15:41
By: Member2014
  Restrict the other session for tables
11.2.0.4
By: grpatwari on Wed, 13 September 2017
22 21121 Thu, 28 September 2017 23:20
By: grpatwari
  Finding Date overlap
Oracle 11 g
By: samiran_cts on Mon, 11 September 2017
7 16888 Wed, 13 September 2017 02:17
By: quirks
  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 98856 Wed, 13 September 2017 17:26
By: Solomon Yakobson
  wirting automatically multi files by utl_file.fopen
oracle database, 11g, window
By: a76014 on Sat, 09 September 2017
2 27671 Thu, 14 September 2017 09:39
By: JPBoileau
  UNIQUE CONSTRAINT FOR EXISTING COLUMN WITH DUPLICATE RECORDS
By: Poovaraghavan on Fri, 08 September 2017
12 92027 Mon, 11 September 2017 05:42
By: Roachcoach
  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 289500 Fri, 22 September 2017 07:51
By: Revathi.orafaq
  left outer join of 3 tables
By: suji6281 on Wed, 06 September 2017
9 33698 Fri, 08 September 2017 07:22
By: suji6281
  How to verify if string contains unwanted character
Oracle Db 11g and later
By: ator on Wed, 06 September 2017
6 23874 Tue, 19 September 2017 05:08
By: quirks
  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
8 47424 Sat, 09 September 2017 22:14
By: RichardTo
  how to extract data from oracle table having space in column name using vba code?
By: oracbeg on Tue, 05 September 2017
4 35500 Tue, 05 September 2017 09:01
By: Bill B
  updated column on the same table automatically
11.2.0.4.0 - 64bit Production
By: mist598 on Mon, 04 September 2017
8 16416 Thu, 07 September 2017 11:58
By: Bill B
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 4546 Wed, 06 September 2017 04:51
By: cookiemonster
  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 39056 Tue, 05 September 2017 04:12
By: cookiemonster
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 12278 Wed, 06 September 2017 05:17
By: quirks
  Select u'' from dual; What does u mean? in this sql.
Oracle 11G, 2.0.1
By: chrisindya on Fri, 01 September 2017
2 12701 Tue, 05 September 2017 04:11
By: chrisindya
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 5834 Mon, 04 September 2017 01:37
By: quirks
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 7483 Thu, 31 August 2017 05:36
By: John Watson
  Unexpected weird result A+A' != U
10.2.0.1.0
By: bluetooth420 on Wed, 30 August 2017
7 40512 Fri, 01 September 2017 02:24
By: Roachcoach
icon5.gif Question about printing the result of a recursive subquery factoring with line indents
By: dariyoosh on Tue, 29 August 2017
1 636 Tue, 29 August 2017 17:30
By: dariyoosh
  How to show multiple data in single row
Oracle11g
By: ssyr on Tue, 29 August 2017
4 11109 Fri, 01 September 2017 01:44
By: ssyr
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 Nov 19 00:51:48 CST 2017

Total time taken to generate the page: 0.54563 seconds