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
  join two virtual tables with if-else condition join
Oracle 10g
By: rc3d on Wed, 01 January 2014
9 565 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 1109 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 390 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 308 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 311 Sat, 04 January 2014 09:49
By: BlackSwan
  Need Static SQL
Oracle 10g
By: sss111ind on Mon, 23 December 2013
8 585 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 511 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 703 Sat, 04 January 2014 04:55
By: KimberlyDeborah
  help in sql query
sql
By: simplesanju on Fri, 03 January 2014
4 327 Sat, 04 January 2014 04:07
By: cookiemonster
  SQL query help
By: thinkbig on Fri, 03 January 2014
7 346 Sat, 04 January 2014 01:00
By: Michel Cadot
  Write a trigger - help
By: changshui on Fri, 03 January 2014
2 214 Fri, 03 January 2014 14:58
By: Michel Cadot
  rownum problem
By: mist598 on Fri, 03 January 2014
2 184 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 378 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 1348 Thu, 02 January 2014 12:51
By: pablolee
  Please help me to resolve this
oracle 10g
By: gouthamimony on Thu, 02 January 2014
4 297 Thu, 02 January 2014 11:33
By: Solomon Yakobson
  CURRENT TIME
By: DUTTA@TARUN on Wed, 01 January 2014
4 364 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 14618 Thu, 02 January 2014 10:40
By: sss111ind
  Reading a csv file
Oracle 10g
By: sss111ind on Tue, 31 December 2013
13 569 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 211 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 807 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 246 Thu, 02 January 2014 04:27
By: cookiemonster
  Query with multiple parameters
Oracle 10g
By: m.abdulhaq on Fri, 08 November 2013
11 810 Wed, 01 January 2014 17:01
By: Barbara Boehmer
  Create DB Trigger
Oracle 11g,Win 7
By: Xandot on Wed, 01 January 2014
6 341 Wed, 01 January 2014 13:32
By: John Watson
  Removing empty space
Oracle 10g
By: sss111ind on Sat, 28 December 2013
6 683 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 410 Wed, 01 January 2014 04:06
By: mokarem
  Help with regexp_substr
11g,Windows Server 2008
By: jxh461 on Tue, 31 December 2013
4 330 Wed, 01 January 2014 00:49
By: mokarem
  Convert date & timestamp into seconds
Oracle 11g
By: Nshan on Tue, 31 December 2013
4 325 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 244 Tue, 31 December 2013 01:52
By: Michel Cadot
  sql query
oracle 11g
By: akarra on Mon, 30 December 2013
5 338 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 156 Mon, 30 December 2013 09:54
By: BlackSwan
  sql query problem
windows xp, oracle 11g
By: sudeshna_bio08 on Mon, 30 December 2013
5 382 Mon, 30 December 2013 06:25
By: sudeshna_bio08
  "with" clause Vs. multiple views
9iR2
By: Amine on Mon, 23 December 2013
7 596 Sun, 29 December 2013 11:43
By: cookiemonster
  SQL Problem
11g
By: vgupta_2002 on Sun, 29 December 2013
6 392 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 568 Sun, 29 December 2013 07:57
By: John Watson
  UPDATE MULTIPLE ROWS IN ONE UPDATE PASS
Oracle 11g, Win7
By: nischalinn on Fri, 27 December 2013
3 406 Sun, 29 December 2013 00:11
By: nischalinn
  ORA-30667: cannot drop NOT NULL constraint on a DEFAULT ON NULL column
Oracle 12.1.0.1.0 Enterprise Edition 64bit on Windows 7 Professional
By: Barbara Boehmer on Thu, 26 December 2013
11 708 Fri, 27 December 2013 14:19
By: Barbara Boehmer
  TABLE TYPES with clustered
11g
By: Sreekumarkv on Fri, 27 December 2013
1 189 Fri, 27 December 2013 13:50
By: Michel Cadot
  How to find values from one record in a string from another record?
TOAD PLSQL
By: bws93222 on Fri, 13 December 2013
16 894 Fri, 27 December 2013 12:38
By: bws93222
  find no of times a column is queried on a table
10G
By: vssunil86 on Fri, 27 December 2013
1 234 Fri, 27 December 2013 01:28
By: Michel Cadot
  Reference Partitioning
Oracle 11g
By: srinivas.k2005 on Tue, 24 December 2013
22 985 Thu, 26 December 2013 23:20
By: srinivas.k2005
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: Fri Apr 18 14:07:56 CDT 2014

Total time taken to generate the page: 0.21943 seconds