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
  How to Resolve error: ORA-00932
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 13 December 2015
10 754 Mon, 14 December 2015 05:40
By: msol25
  + 0 in the where clause
PL/SQL Release 12.1.0.2.0 - Production
By: msinha8 on Thu, 10 December 2015
8 898 Fri, 11 December 2015 01:25
By: Michel Cadot
  Join on TABLE OF NUMBER passed as a parameter to a function
Oracle 11G
By: Sam D. on Wed, 09 December 2015
11 787 Thu, 10 December 2015 13:15
By: Michel Cadot
  merging the column in SQL
PL/SQL Release 12.1.0.2.0 - Production
By: msinha8 on Thu, 05 November 2015
4 700 Thu, 10 December 2015 08:22
By: Michel Cadot
  Fiscal Year data counts
11.2
By: lott42 on Wed, 09 December 2015
2 469 Wed, 09 December 2015 12:11
By: lott42
  Getting Error inListagg
Oracle10g
By: ssyr22 on Mon, 07 December 2015
8 625 Wed, 09 December 2015 11:01
By: Michel Cadot
  Load data
11.2.0.3, 64-bit, Windows 2003
By: sant_new1 on Tue, 08 December 2015
6 522 Wed, 09 December 2015 08:54
By: sant_new1
  Comma separated values
Oracle10g
By: ssyr22 on Wed, 09 December 2015
4 478 Wed, 09 December 2015 06:38
By: EdStevens
  Find Out Odd Range
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Mon, 07 December 2015
9 628 Wed, 09 December 2015 06:26
By: Michel Cadot
  Help with insert
11.2.0.3, 64-bit, Windows 2003
By: sant_new1 on Tue, 08 December 2015
11 534 Tue, 08 December 2015 15:06
By: sant_new1
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
1 481 Mon, 07 December 2015 23:39
By: Michel Cadot
  Cannot group third column (Querying)
By: fabi88 on Mon, 07 December 2015
3 385 Mon, 07 December 2015 13:45
By: John Watson
  Subqyery with group by / case when / having
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
By: Kruemel on Mon, 07 December 2015
8 564 Mon, 07 December 2015 09:43
By: Solomon Yakobson
  Compilation error in Function
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production, WINDOWS-7
By: mokarem on Mon, 07 December 2015
11 573 Mon, 07 December 2015 05:45
By: mokarem
  Oracle pair combination with two column values in a table
Oracle 11g
By: sunshine on Sat, 29 August 2015
15 1489 Sun, 06 December 2015 15:56
By: sunshine
  Regular Expression
Oracle 11G
By: samyms on Fri, 20 November 2015
8 907 Sun, 06 December 2015 10:22
By: samyms
  Distribute payments over due dates and amounts
11.2.1.0
By: OraFerro on Tue, 01 December 2015
5 636 Sat, 05 December 2015 21:56
By: OraFerro
  Data export to flat file (merged 3)
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0, Linix
By: raghx on Tue, 01 December 2015
6 648 Sat, 05 December 2015 07:23
By: Solomon Yakobson
  Query not processing by JDBC (Hanging on the executeQuery line)
Java, Mysql, SQL
By: deepak416 on Sat, 05 December 2015
3 415 Sat, 05 December 2015 06:22
By: Solomon Yakobson
  execute immediate results in an ORA-00936 error
Oracle Enterprise Edition, 11.2.0.3.4, Solaris 10
By: markhooper99 on Thu, 03 December 2015
13 924 Sat, 05 December 2015 06:12
By: pablolee
  Update multiple rows with multi join
oracle 12c
By: gorants on Fri, 04 December 2015
12 650 Fri, 04 December 2015 21:14
By: gorants
icon5.gif How to fill a column with given values?
By: quirks on Fri, 04 December 2015
3 466 Fri, 04 December 2015 07:04
By: Solomon Yakobson
  Grouping with sum and retain first row
oracle 11g
By: bamboo123 on Thu, 03 December 2015
2 360 Thu, 03 December 2015 14:06
By: Michel Cadot
  Determine all data between 2 dates
By: parawos on Thu, 03 December 2015
5 422 Thu, 03 December 2015 03:33
By: Michel Cadot
  SQL update
11.2.0.3, 64-bit, Windows 2003
By: sant_new on Wed, 02 December 2015
2 383 Wed, 02 December 2015 23:46
By: Michel Cadot
  Date issues
Oracle, 11.2.0.4.0, Windows 7 Professional
By: buggleboy007 on Tue, 01 December 2015
7 641 Wed, 02 December 2015 14:21
By: EdStevens
  get 7 working day excluding holidays in Oracle
Oracle 11g
By: manoj12 on Wed, 02 December 2015
10 677 Wed, 02 December 2015 11:17
By: Michel Cadot
icon5.gif Query
Oracle 11g
By: kashif.masood.hashmi on Wed, 02 December 2015
3 440 Wed, 02 December 2015 05:33
By: Lalit Kumar B
  Flattening out a table
Oracle 10G
By: mxz25 on Thu, 13 June 2013
9 5512 Mon, 30 November 2015 08:00
By: gazzag
  Query execute time versus fetch time
11.2.1.0
By: OraFerro on Wed, 18 November 2015
35 43001 Mon, 30 November 2015 00:03
By: OraFerro
  Display Employee details with min & max hired date
Oracle 11g
By: arifs3738 on Sun, 29 November 2015
4 2571 Sun, 29 November 2015 11:40
By: BlackSwan
  sql - transpose
By: rankrose on Fri, 31 July 2015
12 9649 Sun, 29 November 2015 08:04
By: Michel Cadot
  Delete duplicate records without Rowid and drop (2 Merged)
Oracle 10G Pl/Sql ( 1 2)
By: bonvivant on Sat, 07 April 2012
41 48277 Sat, 28 November 2015 11:57
By: Solomon Yakobson
  Closing cursors - but its does not? Error: maximum open cursors exceeded
Oracle 12c
By: wmgonzalbo on Sat, 28 November 2015
2 444 Sat, 28 November 2015 08:19
By: BlackSwan
  sql queries
oracle 11g sql developer
By: sabsac on Mon, 23 November 2015
18 842 Sat, 28 November 2015 02:31
By: Michel Cadot
  SQL Query Suggestion
Oracle 12c
By: msambasiva on Fri, 27 November 2015
4 478 Fri, 27 November 2015 11:20
By: msambasiva
  SQL Query Help
Oracle 11g
By: arifs3738 on Tue, 17 November 2015
7 853 Fri, 27 November 2015 06:03
By: arifs3738
  SQL Query Help
Oracle 11g
By: arifs3738 on Mon, 16 November 2015
7 1053 Fri, 27 November 2015 06:00
By: arifs3738
  count of tests
10
By: pratik4891 on Thu, 26 November 2015
16 1741 Fri, 27 November 2015 01:58
By: pratik4891
  Decode expression help
By: redhonda9834 on Tue, 24 November 2015
7 704 Wed, 25 November 2015 07:10
By: redhonda9834
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 Jun 26 23:17:30 CDT 2016

Total time taken to generate the page: 0.07824 seconds