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
  SQL Query execute more records in WHERE CLAUSE
Oracle Database 10g, Windows XP
By: rehmankhan on Wed, 23 January 2019
3 2544 Thu, 24 January 2019 04:10
By: cookiemonster
  changing telephone format
12c
By: m.abdulhaq on Thu, 24 January 2019
4 2434 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 3796 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 3633 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 3100 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 4404 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 4276 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 5956 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 6109 Fri, 11 January 2019 11:26
By: Michel Cadot
  wm_concat to listagg
By: zxx2403 on Mon, 07 January 2019
1 3001 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 4678 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 2305 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 2652 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 2814 Fri, 04 January 2019 03:53
By: cookiemonster
  filter based on extracting string
12c
By: m.abdulhaq on Thu, 03 January 2019
5 3127 Thu, 03 January 2019 05:59
By: Michel Cadot
  Substring and Instring in combination
11G
By: ABG on Wed, 02 January 2019
3 3009 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 4932 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 3738 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 3480 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 2990 Mon, 24 December 2018 11:26
By: Bill B
  Assign same Group id to rows
By: purnima1 on Sat, 06 October 2018
4 3435 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 2414 Thu, 20 December 2018 13:56
By: Solomon Yakobson
  date conversion
oracle 11g
By: guddu_12 on Thu, 20 December 2018
6 2808 Thu, 20 December 2018 10:17
By: Michel Cadot
  Count function
11G
By: ABG on Wed, 19 December 2018
6 2971 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 2489 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 4513 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 3348 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 8313 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 12005 Tue, 18 December 2018 07:17
By: Barbara Boehmer
  APEX (merged 3 duplicate posts)
Oracle APEX
By: rkapex on Tue, 18 December 2018
5 2386 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 3377 Mon, 17 December 2018 04:06
By: Andrey_R
  Trigger Error ORA-00604
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: wtolentino on Thu, 13 December 2018
8 4427 Thu, 13 December 2018 12:24
By: joy_division
  Question on rank over partition
Oracle 11g
By: fonzi on Sun, 09 December 2018
16 4163 Mon, 10 December 2018 06:27
By: fonzi
  Problem with the product user profile
Oracle 12c Release 2
By: petar97 on Fri, 07 December 2018
12 6261 Mon, 10 December 2018 03:24
By: cookiemonster
  Need some help understanding parallels
oracle 12c, Red Hat Linux
By: sureshonly@hotmail.com on Wed, 05 December 2018
9 3566 Sat, 08 December 2018 08:33
By: BlackSwan
  Column union
11.1.2.10
By: OraFerro on Thu, 06 December 2018
9 2375 Thu, 06 December 2018 14:08
By: Michel Cadot
  Fill in missing data
12.2
By: lott42_gmail on Thu, 06 December 2018
1 1779 Thu, 06 December 2018 13:36
By: lott42_gmail
  SQL Help
12.2.0.1
By: kapilavastu on Thu, 15 November 2018
6 6246 Tue, 04 December 2018 08:07
By: joy_division
icon5.gif How to use Optimistic locking in my Package
Oracle 12c Release 2 ( 1 2 3)
By: petar97 on Thu, 08 November 2018
80 22687 Mon, 03 December 2018 04:59
By: cookiemonster
  Charater set
Oracle Database, 12.1.0.2,Windows
By: youngb912 on Tue, 27 November 2018
9 4507 Fri, 30 November 2018 06:27
By: gazzag
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 Apr 01 10:43:51 CDT 2020