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
  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 73783 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 24171 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 21360 Mon, 04 September 2017 02:26
By: quirks
  SQL Query
Oracle 11g
By: sql_123 on Thu, 24 August 2017
5 26166 Mon, 04 September 2017 02:00
By: quirks
  mysql statement to PL/SQL
By: winfire on Fri, 01 September 2017
6 12052 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 17990 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 76061 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 20749 Fri, 01 September 2017 01:44
By: ssyr
  Need help on query
Oracle11g
By: ssyr on Thu, 31 August 2017
1 14351 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 8698 Wed, 30 August 2017 03:12
By: saipradyumn
  REGEXP_INSTR
Oracle 12c,NT
By: pstanand on Wed, 23 August 2017
8 14994 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 2029 Tue, 29 August 2017 17:30
By: dariyoosh
  Invalid Datatype error for record type
Oracle 11g
By: Rotan on Tue, 29 August 2017
3 7729 Tue, 29 August 2017 14:50
By: Solomon Yakobson
  Visualize Processes Vertical
Oracle 12
By: quirks on Mon, 21 August 2017
10 15878 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 23038 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 11934 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 7766 Mon, 28 August 2017 13:30
By: Littlefoot
  Help with PL SQL query - Analytical Function or group by
12c
By: namitanamburi on Tue, 15 August 2017
5 2312 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 19221 Thu, 24 August 2017 10:07
By: samiran_cts
  Applying function on column having multiple datatypes
By: oracbeg on Tue, 22 August 2017
6 2599 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 6471 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 1361 Tue, 22 August 2017 03:43
By: cookiemonster
  Max function
PL SQL
By: OldDog on Sun, 20 August 2017
9 2537 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 10228 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 39322 Sun, 20 August 2017 02:23
By: amjad_alahdal
  function
12c
By: arifmd1705 on Fri, 18 August 2017
3 1645 Fri, 18 August 2017 14:23
By: arifmd1705
  Should I Clean Up My Collections?
11g
By: whdyck on Thu, 17 August 2017
8 216307 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 1882 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 4655 Fri, 18 August 2017 02:26
By: Michel Cadot
  Need to get the comma separated value
By: rajeshsvnr on Mon, 14 August 2017
4 3007 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 2520 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 1915 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 1706 Tue, 15 August 2017 07:37
By: John Watson
  member procedure execution
oracle 11g
By: ynkr999 on Tue, 25 July 2017
3 1748 Tue, 15 August 2017 00:16
By: Barbara Boehmer
  Code Help: Inserting Records based on records in another table meeting certain parameters
Oracle SQL Developer
By: cem616 on Wed, 09 August 2017
6 2118 Mon, 14 August 2017 14:07
By: buggleboy007
  Rectify the code
By: salam_shah on Tue, 08 August 2017
9 3511 Mon, 14 August 2017 06:49
By: Bill B
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
5 1999 Fri, 11 August 2017 01:19
By: Michel Cadot
  extract portion of strings
12c
By: m.abdulhaq on Sat, 05 August 2017
6 3139 Tue, 08 August 2017 23:09
By: m.abdulhaq
  SQL QUERY
oracle 11g 32-bit, windows7
By: shawaj on Fri, 04 August 2017
5 2317 Tue, 08 August 2017 21:28
By: shawaj
  ORA-29279: SMTP permanent error: Unable to relay
Oracle 10g
By: sarfarazahmedv on Tue, 16 August 2011
12 58990 Fri, 04 August 2017 19:16
By: BlackSwan
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 Jul 17 19:48:49 CDT 2019