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 85336 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 29117 Thu, 07 September 2017 11:58
By: Bill B
  phone type sql
By: suji6281 on Fri, 01 September 2017
15 20100 Wed, 06 September 2017 05:17
By: quirks
  where clause between to sysdates
By: dhuuk42 on Wed, 06 September 2017
3 8388 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 64253 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 69714 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 22728 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 19024 Mon, 04 September 2017 02:26
By: quirks
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 25247 Mon, 04 September 2017 02:00
By: quirks
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 10365 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 15996 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 72173 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 19484 Fri, 01 September 2017 01:44
By: ssyr
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 13380 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 7579 Wed, 30 August 2017 03:12
By: saipradyumn
  REGEXP_INSTR
Oracle 12c,NT
By: pstanand on Wed, 23 August 2017
8 13711 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 1357 Tue, 29 August 2017 17:30
By: dariyoosh
  Invalid Datatype error for record type
Oracle 11g
By: Rotan on Tue, 29 August 2017
3 6706 Tue, 29 August 2017 14:50
By: Solomon Yakobson
  Visualize Processes Vertical
Oracle 12
By: quirks on Mon, 21 August 2017
10 13705 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 21536 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 10330 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 7063 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 6835 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 1624 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 17569 Thu, 24 August 2017 10:07
By: samiran_cts
  Applying function on column having multiple datatypes
By: oracbeg on Tue, 22 August 2017
6 1899 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 5695 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 926 Tue, 22 August 2017 03:43
By: cookiemonster
  Max function
PL SQL
By: OldDog on Sun, 20 August 2017
9 1729 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 9381 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 35716 Sun, 20 August 2017 02:23
By: amjad_alahdal
  function
12c
By: arifmd1705 on Fri, 18 August 2017
3 1164 Fri, 18 August 2017 14:23
By: arifmd1705
  Should I Clean Up My Collections?
11g
By: whdyck on Thu, 17 August 2017
8 205979 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 1151 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 2174 Fri, 18 August 2017 02:26
By: Michel Cadot
  Need to get the comma separated value
By: rajeshsvnr on Mon, 14 August 2017
4 2430 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 1971 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 1234 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 1161 Tue, 15 August 2017 07:37
By: John Watson
  member procedure execution
oracle 11g
By: ynkr999 on Tue, 25 July 2017
3 1075 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 Nov 18 13:10:03 CST 2018