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
  duplicate column
By: nataliafoster26 on Mon, 06 January 2014
9 597 Tue, 07 January 2014 07:12
By: gazzag
  DML written on a script autocommits after a DDL in the same script without any commit statements?
oracle,10g,xp
By: evivek on Tue, 07 January 2014
3 235 Tue, 07 January 2014 05:07
By: evivek
  Dynamic Column List in Select query
oracle 11g linux
By: deepa_balu on Mon, 06 January 2014
5 396 Tue, 07 January 2014 03:28
By: dariyoosh
  Can a procedure have multiple OUT sy_refcursor
oracle 11g
By: gentleman777us on Mon, 06 January 2014
4 325 Tue, 07 January 2014 02:13
By: Michel Cadot
  How to Display Multiple rows in a single row but in different columns
Oracle 11.2
By: deepugun on Mon, 06 January 2014
6 511 Tue, 07 January 2014 01:57
By: Lalit Kumar B
  Decode explanation
By: mist598 on Mon, 06 January 2014
2 286 Tue, 07 January 2014 00:03
By: mist598
  ORA-00907: missing right parenthesis
By: mist598 on Sun, 05 January 2014
12 783 Mon, 06 January 2014 23:01
By: mist598
  join two virtual tables with if-else condition join
Oracle 10g
By: rc3d on Wed, 01 January 2014
9 661 Mon, 06 January 2014 06:51
By: cookiemonster
  Help In optimizing My Query Required Urgently
Oracle Tool Used Toad
By: amit_jha05 on Fri, 03 January 2014
28 1207 Sun, 05 January 2014 10:34
By: Littlefoot
icon5.gif Sql query showing time problem
Oracle,11g,Windows Xp
By: myadi26 on Sun, 05 January 2014
3 462 Sun, 05 January 2014 09:27
By: flyboy
  How to send a Blob variable to a remote server
11gR2
By: Amine on Fri, 03 January 2014
4 353 Sat, 04 January 2014 14:05
By: BlackSwan
  ORA-00054: resource busy and acquire with NOWAIT specified or timeout
11g
By: cplusplus1 on Sat, 04 January 2014
4 358 Sat, 04 January 2014 09:49
By: BlackSwan
  Need Static SQL
Oracle 10g
By: sss111ind on Mon, 23 December 2013
8 687 Sat, 04 January 2014 07:46
By: Kevin Meade
  QUERY FOR HOW TO ACCESS NEXT ROW WHILE IN CURRENT ROW
oracle 9i / 10g
By: msaom on Sat, 04 January 2014
13 574 Sat, 04 January 2014 06:19
By: msaom
  Fetch one row with exact that value with different data type
By: KimberlyDeborah on Fri, 27 December 2013
14 782 Sat, 04 January 2014 04:55
By: KimberlyDeborah
  SQL query help
By: thinkbig on Fri, 03 January 2014
7 407 Sat, 04 January 2014 01:00
By: Michel Cadot
  Write a trigger - help
By: changshui on Fri, 03 January 2014
2 259 Fri, 03 January 2014 14:58
By: Michel Cadot
  rownum problem
By: mist598 on Fri, 03 January 2014
2 211 Fri, 03 January 2014 02:17
By: mist598
  Please provide best approach for my requirement.
Oracle 11g
By: ramya_162 on Wed, 01 January 2014
3 432 Fri, 03 January 2014 01:12
By: Michel Cadot
  PLS-00103: Encountered the symbol ";" when expecting one of the following error?
11g
By: ashwanth77 on Tue, 31 December 2013
23 1600 Thu, 02 January 2014 12:51
By: pablolee
  Please help me to resolve this
oracle 10g
By: gouthamimony on Thu, 02 January 2014
4 355 Thu, 02 January 2014 11:33
By: Solomon Yakobson
  CURRENT TIME
By: DUTTA@TARUN on Wed, 01 January 2014
4 400 Thu, 02 January 2014 11:13
By: Littlefoot
  ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit
Oracle 10.2.03
By: anbazrws on Sun, 03 February 2008
10 15429 Thu, 02 January 2014 10:40
By: sss111ind
  Reading a csv file
Oracle 10g
By: sss111ind on Tue, 31 December 2013
13 663 Thu, 02 January 2014 10:17
By: sss111ind
  Please help me to rewrite this
Oracle 11g
By: ramya_162 on Thu, 02 January 2014
3 237 Thu, 02 January 2014 08:24
By: BlackSwan
  don't want to print line if records are not found
By: mist598 on Thu, 02 January 2014
20 865 Thu, 02 January 2014 04:36
By: Michel Cadot
  How to create outer Join in this Query
By: qanita786 on Thu, 02 January 2014
4 272 Thu, 02 January 2014 04:27
By: cookiemonster
  Query with multiple parameters
Oracle 10g
By: m.abdulhaq on Fri, 08 November 2013
11 892 Wed, 01 January 2014 17:01
By: Barbara Boehmer
  Create DB Trigger
Oracle 11g,Win 7
By: Xandot on Wed, 01 January 2014
6 395 Wed, 01 January 2014 13:32
By: John Watson
  Removing empty space
Oracle 10g
By: sss111ind on Sat, 28 December 2013
6 867 Wed, 01 January 2014 10:30
By: shahzad-ul-hasan
  FLASHBACK_TRANSACTION_QUERY.UNDO_SQL column
Oracle 11g R2
By: mokarem on Tue, 31 December 2013
6 494 Wed, 01 January 2014 04:06
By: mokarem
  Help with regexp_substr
11g,Windows Server 2008
By: jxh461 on Tue, 31 December 2013
4 384 Wed, 01 January 2014 00:49
By: mokarem
  Convert date & timestamp into seconds
Oracle 11g
By: Nshan on Tue, 31 December 2013
4 430 Tue, 31 December 2013 05:45
By: Lalit Kumar B
  Passing an collection of data as an input parameter to an procedure and insert them into a table?
11g running on Windows
By: ashwanth77 on Tue, 31 December 2013
3 289 Tue, 31 December 2013 01:52
By: Michel Cadot
  sql query
oracle 11g
By: akarra on Mon, 30 December 2013
5 390 Mon, 30 December 2013 12:55
By: Michel Cadot
  insert query getting values using select getting next id logic
By: cplusplus1 on Mon, 30 December 2013
1 177 Mon, 30 December 2013 09:54
By: BlackSwan
  sql query problem
windows xp, oracle 11g
By: sudeshna_bio08 on Mon, 30 December 2013
5 442 Mon, 30 December 2013 06:25
By: sudeshna_bio08
  "with" clause Vs. multiple views
9iR2
By: Amine on Mon, 23 December 2013
7 682 Sun, 29 December 2013 11:43
By: cookiemonster
  SQL Problem
11g
By: vgupta_2002 on Sun, 29 December 2013
6 442 Sun, 29 December 2013 11:19
By: Michel Cadot
  move data from one table to another table
By: mist598 on Fri, 27 December 2013
8 637 Sun, 29 December 2013 07:57
By: John Watson
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: Thu Jul 31 10:39:37 CDT 2014

Total time taken to generate the page: 0.06352 seconds