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
  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 481184 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 67501 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 52727 Thu, 21 September 2017 09:16
By: manikandan23
  Update Logic
Oracle,12c,NT
By: pstanand on Wed, 20 September 2017
7 2236 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 31820 Wed, 20 September 2017 11:47
By: grpatwari
  compare 2 collections data
Oracle 12c
By: sss111ind on Wed, 20 September 2017
5 64619 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 89264 Tue, 19 September 2017 15:58
By: philipebe
  split name
By: suji6281 on Fri, 15 September 2017
10 99382 Tue, 19 September 2017 08:43
By: suji6281
  finding status
12c
By: m.abdulhaq on Fri, 15 September 2017
2 20157 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 44839 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 96868 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 10212 Mon, 18 September 2017 09:11
By: sss111ind
  Large volume data compare - NEED HELP
Oracle 11
By: Member2014 on Wed, 13 September 2017
12 48655 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 4676 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 50935 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 156018 Wed, 13 September 2017 17:26
By: Solomon Yakobson
  Finding Date overlap
Oracle 11 g
By: samiran_cts on Mon, 11 September 2017
7 26140 Wed, 13 September 2017 02:17
By: quirks
  UNIQUE CONSTRAINT FOR EXISTING COLUMN WITH DUPLICATE RECORDS
By: Poovaraghavan on Fri, 08 September 2017
12 124507 Mon, 11 September 2017 05:42
By: Roachcoach
  left outer join of 3 tables
By: suji6281 on Wed, 06 September 2017
9 47386 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 87285 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 29825 Thu, 07 September 2017 11:58
By: Bill B
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 20516 Wed, 06 September 2017 05:17
By: quirks
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 8631 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 65824 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 71316 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 23275 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 19441 Mon, 04 September 2017 02:26
By: quirks
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 25476 Mon, 04 September 2017 02:00
By: quirks
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 10703 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 16415 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 73766 Fri, 01 September 2017 02:24
By: Roachcoach
  How to show multiple data in single row
Oracle11g
By: ssyr on Tue, 29 August 2017
4 19945 Fri, 01 September 2017 01:44
By: ssyr
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 13710 Thu, 31 August 2017 05:36
By: John Watson
  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 7785 Wed, 30 August 2017 03:12
By: saipradyumn
  REGEXP_INSTR
Oracle 12c,NT
By: pstanand on Wed, 23 August 2017
8 14064 Wed, 30 August 2017 02:37
By: pstanand
icon5.gif Question about printing the result of a recursive subquery factoring with line indents
By: dariyoosh on Tue, 29 August 2017
1 1449 Tue, 29 August 2017 17:30
By: dariyoosh
  Invalid Datatype error for record type
Oracle 11g
By: Rotan on Tue, 29 August 2017
3 6926 Tue, 29 August 2017 14:50
By: Solomon Yakobson
  Visualize Processes Vertical
Oracle 12
By: quirks on Mon, 21 August 2017
10 14050 Tue, 29 August 2017 06:19
By: quirks
  Oracle lookup function in loop returns rowtype how to get fields from rowtype
Oracle 12g
By: jokrasa on Fri, 25 August 2017
3 22040 Tue, 29 August 2017 03:38
By: cookiemonster
  Error Linking to C DLL from PL/SQL
Local Oracle 12c - Windows 10
By: jhgerold on Mon, 28 August 2017
8 10630 Mon, 28 August 2017 15:53
By: jhgerold
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 Dec 12 22:02:55 CST 2018