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
  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 57828 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 19881 Thu, 07 September 2017 11:58
By: Bill B
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 15769 Wed, 06 September 2017 05:17
By: quirks
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 5520 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 43082 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 47418 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 15412 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 15151 Mon, 04 September 2017 02:26
By: quirks
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 22397 Mon, 04 September 2017 02:00
By: quirks
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 6973 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 10688 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 49135 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 13378 Fri, 01 September 2017 01:44
By: ssyr
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 9033 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 5078 Wed, 30 August 2017 03:12
By: saipradyumn
  REGEXP_INSTR
Oracle 12c,NT
By: pstanand on Wed, 23 August 2017
8 9418 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 798 Tue, 29 August 2017 17:30
By: dariyoosh
  Invalid Datatype error for record type
Oracle 11g
By: Rotan on Tue, 29 August 2017
3 4298 Tue, 29 August 2017 14:50
By: Solomon Yakobson
  Visualize Processes Vertical
Oracle 12
By: quirks on Mon, 21 August 2017
10 10241 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 14805 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 6815 Mon, 28 August 2017 15:53
By: jhgerold
  Cursor within a cursor
Oracle Database 11g Enterprise Edition Release
By: megha2525 on Mon, 28 August 2017
1 4734 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 4670 Mon, 28 August 2017 07:31
By: BlackSwan
  Help with PL SQL query - Analytical Function or group by
12c
By: namitanamburi on Tue, 15 August 2017
5 938 Sat, 26 August 2017 07:47
By: Flyby
  Wanted to delete duplicate records
Oracle 11 g
By: samiran_cts on Tue, 22 August 2017
8 13829 Thu, 24 August 2017 10:07
By: samiran_cts
  Applying function on column having multiple datatypes
By: oracbeg on Tue, 22 August 2017
6 1098 Tue, 22 August 2017 07:51
By: joy_division
  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 3727 Tue, 22 August 2017 07:43
By: Michel Cadot
  File compressing is not happening
Oracle 11g , 11.2.0.3.0
By: mm_kanish05 on Tue, 22 August 2017
2 484 Tue, 22 August 2017 03:43
By: cookiemonster
  Max function
PL SQL
By: OldDog on Sun, 20 August 2017
9 905 Tue, 22 August 2017 02:51
By: quirks
  Join and group by on multiple tables
Oracle 11g
By: kishor9329 on Mon, 21 August 2017
2 6359 Mon, 21 August 2017 08:10
By: Bill B
  Solution for ora-00020 maximum number of processes
oracle database 8i
By: amjad_alahdal on Thu, 20 July 2017
17 28201 Sun, 20 August 2017 02:23
By: amjad_alahdal
  function
12c
By: arifmd1705 on Fri, 18 August 2017
3 731 Fri, 18 August 2017 14:23
By: arifmd1705
  Should I Clean Up My Collections?
11g
By: whdyck on Thu, 17 August 2017
8 160870 Fri, 18 August 2017 09:37
By: whdyck
  Triggers on editioning views inheriting trigger events from NEWER editions
Oracle Database - Enterprise Edition Product Version 12.1.0.2 Linux x86-64 OS Version Red Hat Enterprise 6
By: fixxxer on Wed, 16 August 2017
7 578 Fri, 18 August 2017 05:36
By: Michel Cadot
  Setting Edition // Remote Database
Oracle 11.2.0.4
By: suddhasatwa_oracle on Mon, 07 August 2017
13 884 Fri, 18 August 2017 02:26
By: Michel Cadot
  Need to get the comma separated value
By: rajeshsvnr on Mon, 14 August 2017
4 1045 Thu, 17 August 2017 12:05
By: rajeshsvnr
  Determine filePath/Name from UTL_FILE.FILE_TYPE?
Oracle 11g
By: bkuhn on Wed, 16 August 2017
4 828 Thu, 17 August 2017 09:20
By: bkuhn
  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 640 Wed, 16 August 2017 20:47
By: Barbara Boehmer
  MISSING DATE
oracle 11g , database 11g, windows 7
By: hisham99 on Tue, 15 August 2017
6 546 Tue, 15 August 2017 07:37
By: John Watson
  member procedure execution
oracle 11g
By: ynkr999 on Tue, 25 July 2017
3 473 Tue, 15 August 2017 00:16
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: Sun Feb 25 06:26:08 CST 2018

Total time taken to generate the page: 0.01767 seconds