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
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 5992 Mon, 04 September 2017 01:37
By: quirks
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 7682 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 41737 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 656 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 11462 Fri, 01 September 2017 01:44
By: ssyr
  Invalid Datatype error for record type
Oracle 11g
By: Rotan on Tue, 29 August 2017
3 3608 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 5811 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 4358 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 12814 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 4069 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 3944 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 8884 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 12735 Tue, 29 August 2017 03:38
By: cookiemonster
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 21515 Mon, 04 September 2017 02:00
By: quirks
  REGEXP_INSTR
Oracle 12c,NT
By: pstanand on Wed, 23 August 2017
8 8158 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 12797 Thu, 24 August 2017 10:07
By: samiran_cts
  Applying function on column having multiple datatypes
By: oracbeg on Tue, 22 August 2017
6 934 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 402 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 3184 Tue, 22 August 2017 07:43
By: Michel Cadot
  Visualize Processes Vertical
Oracle 12
By: quirks on Mon, 21 August 2017
10 9525 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 5497 Mon, 21 August 2017 08:10
By: Bill B
  Max function
PL SQL
By: OldDog on Sun, 20 August 2017
9 760 Tue, 22 August 2017 02:51
By: quirks
  function
12c
By: arifmd1705 on Fri, 18 August 2017
3 643 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 540 Wed, 16 August 2017 20:47
By: Barbara Boehmer
  Determine filePath/Name from UTL_FILE.FILE_TYPE?
Oracle 11g
By: bkuhn on Wed, 16 August 2017
4 344 Thu, 17 August 2017 09:20
By: bkuhn
  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 475 Fri, 18 August 2017 05:36
By: Michel Cadot
  Help with PL SQL query - Analytical Function or group by
12c
By: namitanamburi on Tue, 15 August 2017
5 835 Sat, 26 August 2017 07:47
By: Flyby
  Need to get the comma separated value
By: rajeshsvnr on Mon, 14 August 2017
4 516 Thu, 17 August 2017 12:05
By: rajeshsvnr
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
5 757 Fri, 11 August 2017 01:19
By: Michel Cadot
  MISSING DATE
oracle 11g , database 11g, windows 7
By: hisham99 on Tue, 15 August 2017
6 446 Tue, 15 August 2017 07:37
By: John Watson
  Should I Clean Up My Collections?
11g
By: whdyck on Thu, 17 August 2017
8 136994 Fri, 18 August 2017 09:37
By: whdyck
  Rectify the code
By: salam_shah on Tue, 08 August 2017
9 753 Mon, 14 August 2017 06:49
By: Bill B
  LPX-00230: invalid character 0 (U+0000) found in a Name or Nmtoken
Oracle 10g
By: sss111ind on Mon, 07 August 2017
2 5405 Mon, 18 September 2017 09:11
By: sss111ind
  Setting Edition // Remote Database
Oracle 11.2.0.4
By: suddhasatwa_oracle on Mon, 07 August 2017
13 755 Fri, 18 August 2017 02:26
By: Michel Cadot
  extract portion of strings
12c
By: m.abdulhaq on Sat, 05 August 2017
6 987 Tue, 08 August 2017 23:09
By: m.abdulhaq
  SQL QUERY
oracle 11g 32-bit, windows7
By: shawaj on Fri, 04 August 2017
5 1030 Tue, 08 August 2017 21:28
By: shawaj
  string operations
oracle 11g
By: POGAKU_SANTHOSH on Tue, 01 August 2017
9 1208 Wed, 02 August 2017 06:36
By: Bill B
  Regular Expression : Find and Replace Specific String
Oracle 11g
By: lokimisc on Fri, 28 July 2017
17 17099 Tue, 01 August 2017 13:38
By: Solomon Yakobson
  string aggregation
10g
By: praf1981 on Thu, 27 July 2017
2 1009 Sun, 30 July 2017 23:42
By: Barbara Boehmer
  Help with sql code
10 G
By: ramkumar10 on Wed, 26 July 2017
4 683 Thu, 27 July 2017 22:45
By: ramkumar10
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: Fri Nov 24 01:16:25 CST 2017

Total time taken to generate the page: 0.01823 seconds