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
  running total query
11 g
By: annu-agi on Sat, 21 September 2019
4 3855 Mon, 30 September 2019 06:10
By: Bill B
  Cannot drop a user
oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM
By: janakors on Sun, 15 September 2019
7 4960 Mon, 30 September 2019 05:49
By: Bill B
  date usage in SQL query
By: James1116 on Mon, 23 September 2019
6 3813 Mon, 30 September 2019 05:46
By: Bill B
  Need help with Error: subprogram or cursor reference is out of scope
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
By: rappaj on Thu, 26 September 2019
9 3572 Fri, 27 September 2019 08:48
By: rappaj
  SQL to find Consecutive Halves
By: patneel on Tue, 24 September 2019
2 2277 Wed, 25 September 2019 11:03
By: Solomon Yakobson
  Writing Query but not getting desired output
By: chavva.kiru@gmail.com on Tue, 24 September 2019
6 2968 Wed, 25 September 2019 05:50
By: flyboy
  co related subquery written in Analytical functions
By: chavva.kiru@gmail.com on Tue, 24 September 2019
3 2314 Wed, 25 September 2019 03:31
By: Michel Cadot
  display issue
By: James1116 on Tue, 24 September 2019
4 1977 Tue, 24 September 2019 13:20
By: Michel Cadot
  RETURNING clause returns wrong value upon UPDATE statement
Oracle 11g
By: ermoadam on Mon, 23 September 2019
5 2893 Tue, 24 September 2019 02:21
By: Michel Cadot
  How to call compiled procedure and function in a procedure
Toad 11.5 with Oracle 10g
By: oluranti on Sun, 22 September 2019
9 3466 Mon, 23 September 2019 10:25
By: cookiemonster
  ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: revathitirun on Thu, 12 September 2019
5 3135 Fri, 20 September 2019 06:39
By: revathitirun
  getting informations about processes
Oracle 11 - Unix
By: limner1977 on Thu, 12 September 2019
13 4776 Tue, 17 September 2019 10:35
By: limner1977
  help around LIST_AGG function
oracle 11gr2
By: rajeshkr on Fri, 13 September 2019
4 3236 Tue, 17 September 2019 08:50
By: rajeshkr
  data masking
Oracle 12c 2
By: sss111ind on Thu, 12 September 2019
6 2303 Fri, 13 September 2019 03:25
By: sss111ind
  Sql query to group the values in comma seperated values
Oracle DB 10.2.0.2
By: wantmannu on Wed, 11 September 2019
4 2097 Thu, 12 September 2019 10:13
By: Michel Cadot
  what is utc and gmt
Oracle 12c
By: sss111ind on Wed, 11 September 2019
3 2089 Thu, 12 September 2019 06:26
By: sss111ind
  View not pulling with updated table information
APEX Oracle -PL/SQL
By: WillJ on Tue, 10 September 2019
8 3341 Wed, 11 September 2019 07:28
By: WillJ
  How To Show Column Value separated with colon as well as another column vlaue
Oracle 11G
By: ssyr on Tue, 10 September 2019
6 3507 Wed, 11 September 2019 07:14
By: ssyr
  display data in new column
By: getideas456@gmail.com on Fri, 06 September 2019
6 3571 Tue, 10 September 2019 06:25
By: getideas456@gmail.com
  ORA-00001: unique constraint On Merge Insert
Oracle11g
By: ssyr on Fri, 30 August 2019
7 4530 Tue, 10 September 2019 00:19
By: Michel Cadot
  Procedure SendMail Gmail
Oracle 11
By: fabissilva on Mon, 09 September 2019
0 1223 Mon, 09 September 2019 14:14
By: fabissilva
  BI Publisher Apex web Services
Oracle 11g
By: akarra on Mon, 09 September 2019
1 1348 Mon, 09 September 2019 12:59
By: akarra
  IIF and Oracle
Windows 2003 and Oracle 10g
By: aijaz786 on Thu, 18 February 2010
16 13597 Fri, 06 September 2019 08:32
By: EdStevens
  ORA-29913 ORA-29400 KUP-00554
Oracle 12c
By: kavitha.raj23 on Tue, 03 September 2019
6 4175 Wed, 04 September 2019 06:40
By: EdStevens
  ORA-04068: existing state of packages has been discarded
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Linux Redhat
By: fixxxer on Fri, 30 August 2019
4 3668 Mon, 02 September 2019 05:24
By: fixxxer
  How to remove ordinal suffixes after the numbers
pl/sql developer, windows 10
By: nareshk00 on Thu, 29 August 2019
10 4004 Fri, 30 August 2019 13:47
By: nareshk00
  Purging Data From table!
By: ramya29p on Thu, 04 July 2019
22 10376 Fri, 30 August 2019 02:01
By: oracledev
  Additional Column Indicator for Failed or Passed
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: wtolentino on Thu, 29 August 2019
2 1975 Thu, 29 August 2019 11:45
By: wtolentino
  Create table as select
Oracle 11.2, AIX
By: corina on Wed, 28 August 2019
6 2847 Thu, 29 August 2019 10:38
By: Michel Cadot
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
6 3931 Wed, 28 August 2019 17:01
By: ramkumar10
  Help with sql using analytical functions.
By: ramkumar10 on Thu, 22 August 2019
4 4962 Wed, 28 August 2019 00:33
By: Michel Cadot
icon5.gif Compare two tables to find new/modified/removed records
Oracle DB 11g Enterprise Edition 11.2.0.4.0 - 64bit / Windows 7 x64
By: nickz on Thu, 22 August 2019
3 4500 Fri, 23 August 2019 09:12
By: Bill B
  Dynamic Logic
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: vippysharma on Tue, 20 August 2019
5 4199 Fri, 23 August 2019 01:59
By: vippysharma
  Bursting Program is not being Submitted
By: vharish006 on Wed, 21 August 2019
1 3386 Wed, 21 August 2019 14:58
By: Michel Cadot
  regexp_replace
Oracle 12c
By: sss111ind on Fri, 16 August 2019
6 2809 Tue, 20 August 2019 01:50
By: sss111ind
  xml generation from db
Oracle 12c 2
By: sss111ind on Wed, 14 August 2019
1 1713 Mon, 19 August 2019 03:47
By: sss111ind
  plsql logic
By: yashi7777 on Fri, 16 August 2019
10 2779 Sat, 17 August 2019 10:23
By: Michel Cadot
  Data spliting
11gr2
By: rajeshkr on Mon, 12 August 2019
5 2700 Fri, 16 August 2019 08:46
By: rajeshkr
icon3.gif Materialized View Query
Oracle SQL Developer 4.2.0
By: baboyjames on Thu, 25 July 2019
3 2553 Fri, 16 August 2019 06:22
By: Bill B
  SQL Tuning instead of Cross Join
11G
By: laknar on Thu, 25 July 2019
18 5700 Fri, 16 August 2019 05:50
By: Bill B
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 May 25 05:12:07 CDT 2020