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
  Large volume data compare - NEED HELP
Oracle 11
By: Member2014 on Wed, 13 September 2017
12 31619 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 17910 Thu, 28 September 2017 23:20
By: grpatwari
  Finding Date overlap
Oracle 11 g
By: samiran_cts on Mon, 11 September 2017
7 15483 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 96305 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 26623 Thu, 14 September 2017 09:39
By: JPBoileau
  UNIQUE CONSTRAINT FOR EXISTING COLUMN WITH DUPLICATE RECORDS
By: Poovaraghavan on Fri, 08 September 2017
12 88443 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 222788 Fri, 22 September 2017 07:51
By: Revathi.orafaq
  left outer join of 3 tables
By: suji6281 on Wed, 06 September 2017
9 33173 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 22862 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 45278 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 34123 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 15751 Thu, 07 September 2017 11:58
By: Bill B
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 4379 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 37477 Tue, 05 September 2017 04:12
By: cookiemonster
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 10131 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 12231 Tue, 05 September 2017 04:11
By: chrisindya
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 5628 Mon, 04 September 2017 01:37
By: quirks
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 7201 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 38948 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 615 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 10656 Fri, 01 September 2017 01:44
By: ssyr
  Invalid Datatype error for record type
Oracle 11g
By: Rotan on Tue, 29 August 2017
3 3361 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 5448 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 4069 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 11519 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 3832 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 3669 Mon, 28 August 2017 07:31
By: BlackSwan
  Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g
Oracle 12.1.
By: rkrishna on Sun, 27 August 2017
10 8238 Sun, 03 September 2017 06:38
By: John Watson
  Oracle lookup function in loop returns rowtype how to get fields from rowtype
Oracle 12g
By: jokrasa on Fri, 25 August 2017
3 11886 Tue, 29 August 2017 03:38
By: cookiemonster
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 21017 Mon, 04 September 2017 02:00
By: quirks
  REGEXP_INSTR
Oracle 12c,NT
By: pstanand on Wed, 23 August 2017
8 7605 Wed, 30 August 2017 02:37
By: pstanand
  Wanted to delete duplicate records
Oracle 11 g
By: samiran_cts on Tue, 22 August 2017
8 11009 Thu, 24 August 2017 10:07
By: samiran_cts
  Applying function on column having multiple datatypes
By: oracbeg on Tue, 22 August 2017
6 824 Tue, 22 August 2017 07:51
By: joy_division
  File compressing is not happening
Oracle 11g , 11.2.0.3.0
By: mm_kanish05 on Tue, 22 August 2017
2 385 Tue, 22 August 2017 03:43
By: cookiemonster
  Using Trigger in Oracle DB to update a table in SQL Server DB
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: queeny on Tue, 22 August 2017
5 2981 Tue, 22 August 2017 07:43
By: Michel Cadot
  Visualize Processes Vertical
Oracle 12
By: quirks on Mon, 21 August 2017
10 9114 Tue, 29 August 2017 06:19
By: quirks
  Join and group by on multiple tables
Oracle 11g
By: kishor9329 on Mon, 21 August 2017
2 5152 Mon, 21 August 2017 08:10
By: Bill B
  Max function
PL SQL
By: OldDog on Sun, 20 August 2017
9 727 Tue, 22 August 2017 02:51
By: quirks
  function
12c
By: arifmd1705 on Fri, 18 August 2017
3 607 Fri, 18 August 2017 14:23
By: arifmd1705
  qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/)
By: mlashin on Tue, 08 August 2017
6 514 Wed, 16 August 2017 20:47
By: Barbara Boehmer
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: Mon Oct 23 03:09:34 CDT 2017

Total time taken to generate the page: 0.09848 seconds