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
  PL/SQl query to build a list of interval days
11.2.0.4
By: veepee on Fri, 15 September 2017
8 35846 Thu, 21 September 2017 16:09
By: veepee
  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 3413 Thu, 21 September 2017 09:16
By: manikandan23
  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
43 106703 Thu, 21 September 2017 07:35
By: Bill B
  Update Logic
Oracle,12c,NT
By: pstanand on Wed, 20 September 2017
7 786 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 3299 Wed, 20 September 2017 11:47
By: grpatwari
  Finding characters other than keyboard character
Oracle 10g
By: sss111ind on Wed, 20 September 2017
3 4890 Wed, 20 September 2017 09:19
By: sss111ind
  compare 2 collections data
Oracle 12c
By: sss111ind on Wed, 20 September 2017
5 4988 Wed, 20 September 2017 07:27
By: Solomon Yakobson
Storing of an image into chart of products entry form in BLOB column of products table. (topics merged) has been moved to Forms by the moderator.
  extract numbers from a varchar2 upto non-numeric
12.1.0.2.0
By: philipebe on Tue, 19 September 2017
2 13146 Tue, 19 September 2017 15:58
By: philipebe
  How to insert HINDI word in ORACLE
ORACLE 11G
By: sss111ind on Mon, 18 September 2017
4 16906 Tue, 19 September 2017 03:29
By: cookiemonster
  split name
By: suji6281 on Fri, 15 September 2017
10 32949 Tue, 19 September 2017 08:43
By: suji6281
  finding status
12c
By: m.abdulhaq on Fri, 15 September 2017
2 10233 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 2112 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 20548 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
21 10906 Fri, 15 September 2017 12:35
By: joy_division
  Finding Date overlap
Oracle 11 g
By: samiran_cts on Mon, 11 September 2017
7 12610 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 94731 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 25726 Thu, 14 September 2017 09:39
By: JPBoileau
  UNIQUE CONSTRAINT FOR EXISTING COLUMN WITH DUPLICATE RECORDS
By: Poovaraghavan on Fri, 08 September 2017
12 75460 Mon, 11 September 2017 05:42
By: Roachcoach
  left outer join of 3 tables
By: suji6281 on Wed, 06 September 2017
9 28415 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 20528 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 42482 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 32969 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 14536 Thu, 07 September 2017 11:58
By: Bill B
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 4187 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 35600 Tue, 05 September 2017 04:12
By: cookiemonster
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 6501 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 11784 Tue, 05 September 2017 04:11
By: chrisindya
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 5121 Mon, 04 September 2017 01:37
By: quirks
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 6861 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 37377 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 559 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 9642 Fri, 01 September 2017 01:44
By: ssyr
  Invalid Datatype error for record type
Oracle 11g
By: Rotan on Tue, 29 August 2017
3 3100 Tue, 29 August 2017 14:50
By: Solomon Yakobson
  Error Linking to C DLL from PL/SQL
Local Oracle 12c - Windows 10
By: jhgerold on Mon, 28 August 2017
8 5076 Mon, 28 August 2017 15:53
By: jhgerold
  Conversion into Clob from Varchar2
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Mon, 28 August 2017
4 3613 Wed, 30 August 2017 03:12
By: saipradyumn
  the records with common cust_id should not be shown.
By: adil shakeel on Mon, 28 August 2017
12 7980 Mon, 04 September 2017 02:26
By: quirks
  Cursor within a cursor
Oracle Database 11g Enterprise Edition Release
By: megha2525 on Mon, 28 August 2017
1 3560 Mon, 28 August 2017 13:30
By: Littlefoot
  Compare and contrast TRUNCATE and DELETE for a table
By: Meenakumari on Mon, 28 August 2017
3 3425 Mon, 28 August 2017 07:31
By: BlackSwan
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: Thu Sep 21 23:30:33 CDT 2017

Total time taken to generate the page: 0.21937 seconds