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 read UNCOMMITED data in Oracle?
Oracle 11g Enterprise Edition 11.2.0.1.0 - Linux 2.6
By: usaha1 on Thu, 09 January 2014
12 587 Thu, 09 January 2014 05:46
By: usaha1
  SELECT * FROM OPENQUERY([127.0.0.1],'@cmd') (merged)
By: phuong on Mon, 21 May 2007
7 1933 Wed, 08 January 2014 18:33
By: BlackSwan
  UPDATE only rows which match another table
By: alexandercioby on Tue, 07 January 2014
7 715 Wed, 08 January 2014 15:19
By: joy_division
  weighted average or moving average calculation for stock
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
By: hissam78 on Sat, 04 January 2014
3 531 Wed, 08 January 2014 13:54
By: hissam78
  compare null in decode
By: mist598 on Wed, 08 January 2014
7 503 Wed, 08 January 2014 12:19
By: Solomon Yakobson
  Group the same values and show the ascending order.
Oracle 11g
By: na.dharma@gmail.com on Wed, 08 January 2014
2 167 Wed, 08 January 2014 10:10
By: BlackSwan
  sql code error meaning
Oracle 11g, Win7
By: nischalinn on Wed, 08 January 2014
10 502 Wed, 08 January 2014 06:11
By: pablolee
  Read a .csv file which has more than 45000 Characters
By: sivakarthick on Wed, 08 January 2014
7 431 Wed, 08 January 2014 04:31
By: gazzag
  can a string be used with IN within a query?
11g
By: VAC357 on Tue, 07 January 2014
5 333 Tue, 07 January 2014 14:14
By: Michel Cadot
  duplicate column
By: nataliafoster26 on Mon, 06 January 2014
9 609 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 246 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 413 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 338 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 526 Tue, 07 January 2014 01:57
By: Lalit Kumar B
  Decode explanation
By: mist598 on Mon, 06 January 2014
2 300 Tue, 07 January 2014 00:03
By: mist598
  ORA-00907: missing right parenthesis
By: mist598 on Sun, 05 January 2014
12 831 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 680 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 1234 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 483 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 374 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 363 Sat, 04 January 2014 09:49
By: BlackSwan
  Need Static SQL
Oracle 10g
By: sss111ind on Mon, 23 December 2013
8 703 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 580 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 800 Sat, 04 January 2014 04:55
By: KimberlyDeborah
  SQL query help
By: thinkbig on Fri, 03 January 2014
7 423 Sat, 04 January 2014 01:00
By: Michel Cadot
  Write a trigger - help
By: changshui on Fri, 03 January 2014
2 270 Fri, 03 January 2014 14:58
By: Michel Cadot
  rownum problem
By: mist598 on Fri, 03 January 2014
2 226 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 448 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 1663 Thu, 02 January 2014 12:51
By: pablolee
  Please help me to resolve this
oracle 10g
By: gouthamimony on Thu, 02 January 2014
4 366 Thu, 02 January 2014 11:33
By: Solomon Yakobson
  CURRENT TIME
By: DUTTA@TARUN on Wed, 01 January 2014
4 404 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 15622 Thu, 02 January 2014 10:40
By: sss111ind
  Reading a csv file
Oracle 10g
By: sss111ind on Tue, 31 December 2013
13 682 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 244 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 883 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 285 Thu, 02 January 2014 04:27
By: cookiemonster
  Query with multiple parameters
Oracle 10g
By: m.abdulhaq on Fri, 08 November 2013
11 916 Wed, 01 January 2014 17:01
By: Barbara Boehmer
  Create DB Trigger
Oracle 11g,Win 7
By: Xandot on Wed, 01 January 2014
6 405 Wed, 01 January 2014 13:32
By: John Watson
  Removing empty space
Oracle 10g
By: sss111ind on Sat, 28 December 2013
6 911 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 517 Wed, 01 January 2014 04:06
By: mokarem
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 Aug 27 08:05:43 CDT 2014

Total time taken to generate the page: 0.06434 seconds