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
  Tree View, Connect by Prior on 100m records
Oracle 12c, RED HAT
By: sureshonly@hotmail.com on Sun, 10 February 2019
7 5831 Mon, 11 February 2019 16:05
By: sureshonly@hotmail.com
  Pull out string between two words in string column
Oracle 11g
By: spalato76 on Sat, 09 February 2019
3 4603 Sat, 09 February 2019 23:50
By: spalato76
  Issue in dynamic sql.
Oracle 18c
By: rajeshsvnr on Wed, 06 February 2019
6 5817 Sat, 09 February 2019 06:37
By: Solomon Yakobson
  Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail
Unix
By: Akmmhto on Mon, 04 February 2019
2 4098 Tue, 05 February 2019 06:06
By: Akmmhto
  Account number selection from 10 parallel session
Oracle 11gR2
By: srinivas.k2005 on Fri, 01 February 2019
9 6281 Mon, 04 February 2019 10:16
By: srinivas.k2005
  table export to excel
12c
By: m.abdulhaq on Mon, 04 February 2019
7 5051 Mon, 04 February 2019 10:13
By: cookiemonster
  Do I have to use ID as a PK?
General
By: CatB on Mon, 28 January 2019
17 8218 Wed, 30 January 2019 15:23
By: Bill B
  MULTISET EXCEPT - COLLECTION
12C
By: shawaj on Sat, 26 January 2019
13 7769 Wed, 30 January 2019 05:13
By: _jum
  Identify data based on data in other tables
By: rrcr on Sun, 27 January 2019
14 7685 Tue, 29 January 2019 07:56
By: BlackSwan
  DataMapper - JSON -> XML - Add a colon in XML tag
By: tutu10 on Mon, 28 January 2019
1 3409 Mon, 28 January 2019 03:27
By: _jum
  RETURNING BULK COLLECT INTO COLLECTION
12C
By: shawaj on Fri, 23 November 2018
9 7825 Sat, 26 January 2019 12:15
By: BlackSwan
  SQL Query execute more records in WHERE CLAUSE
Oracle Database 10g, Windows XP
By: rehmankhan on Wed, 23 January 2019
3 4232 Thu, 24 January 2019 04:10
By: cookiemonster
  changing telephone format
12c
By: m.abdulhaq on Thu, 24 January 2019
4 3834 Thu, 24 January 2019 03:45
By: m.abdulhaq
icon5.gif How to simulate crash database?
Oracle 12c Release 2
By: petar97 on Mon, 21 January 2019
8 6452 Mon, 21 January 2019 12:40
By: petar97
  ORA-01843 on a simple query
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Andrey_R on Thu, 17 January 2019
10 7118 Fri, 18 January 2019 10:22
By: Michel Cadot
  Why Do You Need to File a DBA and the Simplest Way of Filing It.
By: inshah2297@gmail.com on Wed, 16 January 2019
4 4789 Thu, 17 January 2019 00:34
By: Michel Cadot
  DBMS_REDACT with MERGE
Oracle 12.1
By: Michael.van.Uffelen on Mon, 14 January 2019
5 7236 Wed, 16 January 2019 09:00
By: Solomon Yakobson
  Spreadsheet-like Totals and Subtotals
11.2
By: lott42_gmail on Fri, 11 January 2019
12 7991 Tue, 15 January 2019 18:29
By: Solomon Yakobson
  Insert Statement taking more than 2 hrs for 4 million records
Oracle 11gR2
By: srinivas.k2005 on Tue, 18 December 2018
21 8687 Mon, 14 January 2019 03:41
By: anil_mk
  Determining a due date based on business hours
Otracle 12.1
By: TerryM on Tue, 08 January 2019
8 9052 Fri, 11 January 2019 11:26
By: Michel Cadot
  wm_concat to listagg
By: zxx2403 on Mon, 07 January 2019
1 5426 Mon, 07 January 2019 23:16
By: Barbara Boehmer
  Proxy Granted But Unable to Modified a Table owned by the Proxy Account
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: wtolentino on Fri, 04 January 2019
9 8005 Mon, 07 January 2019 09:04
By: wtolentino
  What does @! mean in SQL?
Oracle 11.2.0.3
By: SmithXu on Fri, 04 January 2019
1 3789 Fri, 04 January 2019 20:55
By: BlackSwan
  Login table connection to another table.
Oracle 10g
By: Danny Freeman on Fri, 04 January 2019
4 3957 Fri, 04 January 2019 05:43
By: Danny Freeman
icon5.gif Regarding Updatable view - Please assist
By: pessi.ksn on Fri, 04 January 2019
2 4172 Fri, 04 January 2019 03:53
By: cookiemonster
  filter based on extracting string
12c
By: m.abdulhaq on Thu, 03 January 2019
5 4916 Thu, 03 January 2019 05:59
By: Michel Cadot
  Substring and Instring in combination
11G
By: ABG on Wed, 02 January 2019
3 4863 Thu, 03 January 2019 03:20
By: ABG
  TRIM function
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
By: wtolentino on Wed, 10 October 2018
4 7544 Tue, 01 January 2019 00:12
By: Barbara Boehmer
  Transactions than can be rejected, temporary tables or not?
11.1.2.10
By: OraFerro on Mon, 10 December 2018
8 5614 Fri, 28 December 2018 14:09
By: Michel Cadot
  How to flatten one column from multiple rows
Oracle 11.2.9.1.0
By: gunderj on Tue, 18 December 2018
7 5984 Thu, 27 December 2018 08:33
By: Bill B
  NVL not working in Cursor Subquery
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Wed, 19 December 2018
4 5470 Mon, 24 December 2018 11:26
By: Bill B
  Assign same Group id to rows
By: purnima1 on Sat, 06 October 2018
4 5718 Mon, 24 December 2018 05:52
By: Barbara Boehmer
  Date for Sunday prior to given date
Oracle
By: ssmith001 on Thu, 20 December 2018
4 4232 Thu, 20 December 2018 13:56
By: Solomon Yakobson
  date conversion
oracle 11g
By: guddu_12 on Thu, 20 December 2018
6 5685 Thu, 20 December 2018 10:17
By: Michel Cadot
  Count function
11G
By: ABG on Wed, 19 December 2018
6 4925 Thu, 20 December 2018 10:02
By: ABG
  Multiple Row Record Insert Into One Field And Email
Oracle Forms 6i ( User Activity Audit Logs )
By: ka_wish on Thu, 20 December 2018
4 4504 Thu, 20 December 2018 07:18
By: cookiemonster
  Execution plan alters with DDL change
Oracle 11gR2
By: srinivas.k2005 on Fri, 23 November 2018
13 8065 Thu, 20 December 2018 07:06
By: EdStevens
  Error using API
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Thu, 30 August 2018
4 4730 Wed, 19 December 2018 14:26
By: Michel Cadot
  XML Through PL/SQL
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Thu, 01 November 2018
20 11764 Wed, 19 December 2018 14:26
By: Michel Cadot
  APEX (merged 3 duplicate posts)
Oracle APEX
By: rkapex on Tue, 18 December 2018
5 3761 Tue, 18 December 2018 05:55
By: Michel Cadot
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 Mar 22 08:49:19 CDT 2023