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
  Issue in dynamic sql.
Oracle 18c
By: rajeshsvnr on Wed, 06 February 2019
6 3029 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 2377 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 2926 Mon, 04 February 2019 10:16
By: srinivas.k2005
  table export to excel
12c
By: m.abdulhaq on Mon, 04 February 2019
7 2526 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 4998 Wed, 30 January 2019 15:23
By: Bill B
  MULTISET EXCEPT - COLLECTION
12C
By: shawaj on Sat, 26 January 2019
13 4457 Wed, 30 January 2019 05:13
By: _jum
  Identify data based on data in other tables
By: rrcr on Sun, 27 January 2019
14 4889 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 2115 Mon, 28 January 2019 03:27
By: _jum
  RETURNING BULK COLLECT INTO COLLECTION
12C
By: shawaj on Fri, 23 November 2018
9 4806 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 2487 Thu, 24 January 2019 04:10
By: cookiemonster
  changing telephone format
12c
By: m.abdulhaq on Thu, 24 January 2019
4 2382 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 3727 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 3580 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 3052 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 4257 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 4180 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 5908 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 6035 Fri, 11 January 2019 11:26
By: Michel Cadot
  wm_concat to listagg
By: zxx2403 on Mon, 07 January 2019
1 2919 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 4616 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 2269 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 2623 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 2770 Fri, 04 January 2019 03:53
By: cookiemonster
  filter based on extracting string
12c
By: m.abdulhaq on Thu, 03 January 2019
5 3085 Thu, 03 January 2019 05:59
By: Michel Cadot
  Substring and Instring in combination
11G
By: ABG on Wed, 02 January 2019
3 2965 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 4860 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 3662 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 3404 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 2927 Mon, 24 December 2018 11:26
By: Bill B
  Assign same Group id to rows
By: purnima1 on Sat, 06 October 2018
4 3397 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 2377 Thu, 20 December 2018 13:56
By: Solomon Yakobson
  date conversion
oracle 11g
By: guddu_12 on Thu, 20 December 2018
6 2756 Thu, 20 December 2018 10:17
By: Michel Cadot
  Count function
11G
By: ABG on Wed, 19 December 2018
6 2923 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 2447 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 4432 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 3283 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 8195 Wed, 19 December 2018 14:26
By: Michel Cadot
  Duplicating Excel "RATE" function in Oracle
Oracle 11.2
By: Primordial on Wed, 18 February 2015
18 11756 Tue, 18 December 2018 07:17
By: Barbara Boehmer
  APEX (merged 3 duplicate posts)
Oracle APEX
By: rkapex on Tue, 18 December 2018
5 2337 Tue, 18 December 2018 05:55
By: Michel Cadot
  Cannot insert specific char
Oracle 11.2.0.1.0 - 64bit, Linux OEL 6
By: Andrey_R on Sat, 15 December 2018
10 3260 Mon, 17 December 2018 04:06
By: Andrey_R
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 Feb 19 12:47:33 CST 2020