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
  Need to get the top 3 employees whose salary increased in three consecutive year
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Product ,window
By: arpit0508 on Thu, 27 April 2017
6 2516 Mon, 01 May 2017 03:05
By: arpit0508
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 1380 Thu, 27 April 2017 02:23
By: mmohsinaziz
  NOT LIKE operation on the numbers columns
Oracle 12c
By: ora_newbie111 on Sun, 16 April 2017
20 6519 Wed, 26 April 2017 10:47
By: Bill B
  Issue with DATE
By: rajkumar561991 on Tue, 25 April 2017
5 2180 Wed, 26 April 2017 06:49
By: EdStevens
  SQL Tunning - Please Help Me
Oracle 10g
By: parthaspaul@gmail.com on Mon, 17 April 2017
21 5782 Mon, 24 April 2017 18:21
By: mikek
  PLS-00497: cannot mix between single row and multi-row (BULK) in
oracle 10.2.0.4.0 - 64bi linux
By: sundarfaq on Thu, 08 March 2012
6 29463 Mon, 24 April 2017 15:40
By: Barbara Boehmer
  ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT
By: mskphani on Mon, 24 April 2017
4 1709 Mon, 24 April 2017 10:50
By: Michel Cadot
  Taking Sum of Similar Tables
Oracle 11g
By: gobi21 on Sun, 23 April 2017
13 4018 Mon, 24 April 2017 07:45
By: gobi21
  Pivot result using "Pivot" keyword
11.2
By: lott42_gmail on Thu, 20 April 2017
4 1721 Fri, 21 April 2017 12:22
By: lott42_gmail
  LIKE vs NOT LIKE operator
Oracle 12c
By: srinivas.k2005 on Fri, 21 April 2017
4 1451 Fri, 21 April 2017 08:47
By: srinivas.k2005
  DEFINE_COLUMN in DBMS_SQL
Oracle 11.2.0.3
By: pointers on Thu, 20 April 2017
2 1842 Fri, 21 April 2017 02:09
By: pointers
  Need help to form Query to split count into multiple rows
By: rakesh281214 on Wed, 19 April 2017
5 2068 Thu, 20 April 2017 14:30
By: Barbara Boehmer
  merge issue
By: JEWEL78 on Tue, 18 April 2017
11 3667 Thu, 20 April 2017 03:55
By: cookiemonster
  Regexp magic ! (I hope)
11.2.0.3.0
By: Amine on Fri, 14 April 2017
6 1787 Wed, 19 April 2017 01:47
By: Michel Cadot
  pl/sql procedure using cursors
oracle 11g
By: POGAKU_SANTHOSH on Mon, 17 April 2017
3 1456 Mon, 17 April 2017 16:03
By: BlackSwan
  Help required in SQL Analytic Function lag()
Oracle 11gR2 11.2.0.1.0
By: jimit_shaili on Sat, 15 April 2017
5 1752 Mon, 17 April 2017 12:31
By: Michel Cadot
  Partition tablespace name does not change after moving subpartition
oracle12c
By: shrinika on Sat, 15 April 2017
2 1653 Sat, 15 April 2017 12:59
By: shrinika
  cursors
windows
By: jay12 on Tue, 04 April 2017
3 1258 Fri, 14 April 2017 15:49
By: Bill B
  testing rollback
12.1.0.1
By: jinga on Fri, 07 April 2017
2 1274 Tue, 11 April 2017 12:56
By: Bill B
  Hierarchical Queries
Oracle 11.2.0.3
By: pointers on Thu, 06 April 2017
2 1642 Sat, 08 April 2017 07:42
By: pointers
  UNION and dependent LOV
Oracle R12
By: umamagi on Fri, 07 April 2017
3 1820 Sat, 08 April 2017 03:20
By: Littlefoot
  Pre Insert logic in Trigger
Oracle 11.2.0.3
By: pointers on Wed, 05 April 2017
10 2208 Thu, 06 April 2017 21:09
By: pointers
  Avoid Distinct
Oracle 11g
By: manikandan23 on Wed, 05 April 2017
6 2151 Thu, 06 April 2017 03:33
By: cookiemonster
  package
By: jay12 on Wed, 05 April 2017
3 1552 Thu, 06 April 2017 03:30
By: cookiemonster
  Split clob data and store in table
Oracle 11g
By: Roots_ct5 on Tue, 04 April 2017
3 1704 Tue, 04 April 2017 10:30
By: Roots_ct5
  Need a help with SQL
Oracle 12C
By: mangeshbhasme on Sun, 02 April 2017
10 2492 Tue, 04 April 2017 06:59
By: EdStevens
  how to send tablespace mail alerts with PL/SQL
By: diomahardhika on Mon, 13 March 2017
24 7559 Tue, 04 April 2017 03:56
By: cookiemonster
  How can I convert a SQL command to MySql
By: vinodkalpaka on Mon, 03 April 2017
24 6304 Tue, 04 April 2017 03:28
By: vinodkalpaka
  Need help with SQL
Oracle 12c
By: jvanh on Fri, 31 March 2017
11 3384 Mon, 03 April 2017 07:05
By: John Watson
  Converting comma separated value in different rows
Oracle 10g R2
By: amarbose on Sun, 02 April 2017
5 1672 Mon, 03 April 2017 01:34
By: Michel Cadot
  Can we replace any sub query using join
By: asliyanage on Wed, 22 March 2017
3 1317 Sat, 01 April 2017 02:59
By: Michel Cadot
  oracle-dbms-fga-dynamically-create-an-audit-trail-or-policy (3 threads merged by bb)
By: jokrasa on Wed, 22 March 2017
9 3162 Fri, 31 March 2017 11:45
By: Bill B
  Re: ToDate function (split from hijacked thread http://www.orafaq.com/forum/t/56308/ by bb)
By: hyder on Thu, 30 March 2017
2 1296 Fri, 31 March 2017 11:41
By: Bill B
  UTL_FILE_DIR
Oracle 10gR2/ Solaris 10
By: reym21 on Wed, 29 March 2017
13 3159 Thu, 30 March 2017 07:22
By: Bill B
  Avoid UNION ALL
Oracle 11.2.0.3
By: pointers on Tue, 28 March 2017
5 1710 Wed, 29 March 2017 08:14
By: pointers
  Grouping for varying weeks
Oracle 11.2.0.3
By: pointers on Mon, 27 March 2017
7 1844 Tue, 28 March 2017 04:13
By: pointers
  Inserting data from multiple table into 1 table
windows
By: Dnmunde on Sun, 26 March 2017
8 3117 Mon, 27 March 2017 00:48
By: Michel Cadot
  Receiving Email Messages through Oracle procedure. ( 1 2)
By: woolmer on Tue, 01 May 2007
68 33285 Sat, 25 March 2017 13:10
By: Littlefoot
  Query performance
SQL
By: Jiggu on Thu, 16 March 2017
19 6594 Fri, 24 March 2017 04:40
By: Bill B
  CURSOR taking more time
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
By: amarjadhav on Fri, 10 March 2017
11 2192 Thu, 23 March 2017 14:30
By: mikek
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: Sun Jul 12 02:44:12 CDT 2020