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
  SQLException encounter while executing data trigger.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Mon, 20 August 2018
4 5003 Thu, 23 August 2018 11:55
By: cookiemonster
  find circular reference in data
By: purnima1 on Thu, 23 August 2018
4 2898 Thu, 23 August 2018 06:55
By: Solomon Yakobson
  consistency constraint ON store Procedure
12c, window
By: Bilal Khan on Tue, 21 August 2018
22 7482 Tue, 21 August 2018 08:52
By: Solomon Yakobson
  Running settlement of inward vs outward quantity
Oracle 11g
By: chintan.patel on Mon, 20 August 2018
13 5568 Tue, 21 August 2018 08:02
By: quirks
  Relation between two gold
By: purnima1 on Tue, 21 August 2018
3 3292 Tue, 21 August 2018 07:15
By: Michel Cadot
  Joining multiple rows and creating multiple columns
By: purnima1 on Mon, 20 August 2018
9 3774 Tue, 21 August 2018 07:13
By: Michel Cadot
  Strange Issue in executing procedure
Oracle 11g
By: manikandan23 on Wed, 15 August 2018
22 7909 Mon, 20 August 2018 10:01
By: JPBoileau
  Row Movement disabled in Partitioned table
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sun, 19 August 2018
5 4604 Mon, 20 August 2018 06:30
By: Roachcoach
  Prevent Rounding when using Format Masking
Oracle 12.1.0.2.0, RHEL
By: abhi_orcl on Thu, 16 August 2018
6 4965 Fri, 17 August 2018 18:37
By: Solomon Yakobson
  Extracting just text from a Blob Column
11.2
By: dejah on Thu, 16 August 2018
5 3983 Fri, 17 August 2018 18:28
By: Solomon Yakobson
  SQL to Subtract X workdays from a date
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: ssmith001 on Wed, 15 August 2018
32 10958 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 4244 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 2983 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 3808 Thu, 16 August 2018 10:34
By: Michel Cadot
icon5.gif failing in Creation of PL/SQL function
PL SQL ORACLE
By: bench on Wed, 15 August 2018
14 5473 Thu, 16 August 2018 07:44
By: Bill B
  Last 7 days report
oracle 11g
By: akash123 on Wed, 15 August 2018
5 2959 Wed, 15 August 2018 06:24
By: akash123
  XML Special Character
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 14 August 2018
0 3200 Tue, 14 August 2018 15:07
By: vharish006
  Split Data in Column & Split Data in Excel (merged)
Excel 2016
By: vharish006 on Mon, 13 August 2018
7 3903 Mon, 13 August 2018 13:53
By: vharish006
  How to Convert Row to Column As Below
Oracle 11g
By: sonudev on Mon, 13 August 2018
11 4086 Mon, 13 August 2018 08:11
By: joy_division
  Dbms_metadat
12c
By: Kannan Oracle on Fri, 10 August 2018
2 3154 Fri, 10 August 2018 07:42
By: joy_division
  Spool Japanese Characters
Oracle 11g
By: pratyush_biswas on Thu, 09 August 2018
4 4899 Fri, 10 August 2018 07:05
By: Bill B
  PL/SQL Collection
Oracle 11G
By: RaShi.Raj on Thu, 09 August 2018
4 3436 Thu, 09 August 2018 06:43
By: poojagarg
  Get Record Count
Oracle 11g
By: lokimisc on Mon, 06 August 2018
9 5381 Thu, 09 August 2018 04:19
By: pablolee
  Back fill records
Oracle 11.2.0.3
By: pointers on Wed, 08 August 2018
4 3202 Wed, 08 August 2018 14:26
By: Solomon Yakobson
  Create JSON from SQL 12C R1
By: Manoj.Gupta.91 on Mon, 30 July 2018
10 6516 Tue, 31 July 2018 12:36
By: Solomon Yakobson
  OR clause degrades performance of a query?
Oracle database, any, Linux
By: raresn on Mon, 30 July 2018
2 3498 Mon, 30 July 2018 08:31
By: raresn
  Performance of Stored Programs
Oracle 12c , Linux
By: ninan on Sun, 29 July 2018
14 5415 Mon, 30 July 2018 03:02
By: Michel Cadot
  return top 10 records based on dynamic count of prev records results
oracle 11
By: greenwaldliron on Sun, 29 July 2018
7 4893 Sun, 29 July 2018 09:23
By: greenwaldliron
  Possibility of Name
Oracle 11G
By: Genesys on Mon, 16 July 2018
7 7181 Fri, 27 July 2018 20:13
By: Barbara Boehmer
  How to ensure uniqueness on RAISE_APPLICATION_ERROR
By: ramya29p on Mon, 23 July 2018
14 7884 Thu, 26 July 2018 03:27
By: cookiemonster
  passing date value to the query from sql*plus
By: shrinika on Mon, 23 July 2018
3 3966 Tue, 24 July 2018 12:08
By: shrinika
  PL/SQL: ORA-04053: error occurred when validating remote object
oracle12c
By: shrinika on Thu, 11 May 2017
3 5570 Mon, 23 July 2018 11:10
By: Michel Cadot
  Oracle materialized views workflow
By: camillelola on Fri, 20 July 2018
3 3672 Fri, 20 July 2018 13:19
By: Lalit Kumar B
  ORA-04091: table Table_Name is mutating, trigger/function may not see it
Oracle 11g With Apex 5.1
By: Mukul Ahmed on Fri, 13 July 2018
7 7281 Fri, 20 July 2018 04:16
By: elmomagalona
icon1.gif Get last record from another table
11g
By: ritaman on Mon, 16 July 2018
17 7764 Wed, 18 July 2018 05:26
By: cookiemonster
  Need Help on Pl/Sql
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 17 July 2018
11 4843 Tue, 17 July 2018 12:19
By: Lalit Kumar B
  query performance
11g
By: annu-agi on Sat, 14 July 2018
3 5006 Tue, 17 July 2018 06:29
By: Bill B
  how to work around the substitution variables in plsql
Oracle 12c
By: mgag on Mon, 02 July 2018
3 5171 Tue, 17 July 2018 06:26
By: ajaychinna
  Generate New Excel format (XLSX) files using Oracle PLSQL
Oracle 11.2.0.4
By: nickz on Fri, 13 July 2018
3 11671 Mon, 16 July 2018 06:52
By: Bill B
  Need Help on Creating FUNCTION
By: vharish006 on Tue, 10 July 2018
13 6230 Wed, 11 July 2018 03:43
By: cookiemonster
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: Tue May 11 13:03:56 CDT 2021