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
  Capturing OLD and NEW values from the Parameter of a sored procedure
11g
By: mapps0999@gmail.com on Wed, 19 March 2014
11 554 Fri, 21 March 2014 04:24
By: Michel Cadot
  Date and Last7Days
Oracle
By: nag.yalavarthi on Thu, 20 March 2014
1 305 Thu, 20 March 2014 17:19
By: BlackSwan
  Insert user_id if it doesn't already exist.
By: weatherman on Thu, 20 March 2014
5 274 Thu, 20 March 2014 12:19
By: cookiemonster
  can someone tell me why this sp takes so much time?
11g,toad 12.1
By: ashwanth77 on Mon, 17 March 2014
27 1352 Thu, 20 March 2014 11:48
By: cookiemonster
  Issue in inserting table data through DB Link
PL/SQL Release 11.2
By: Chinmay91 on Thu, 20 March 2014
2 190 Thu, 20 March 2014 08:46
By: Chinmay91
icon5.gif variable value's length is not checked during compilition
Oracle 11g, AIX
By: harpreetsinghkup on Fri, 14 March 2014
12 766 Thu, 20 March 2014 08:01
By: Solomon Yakobson
  difference between the two queries
Oracle 11g, Win7
By: nischalinn on Thu, 20 March 2014
2 202 Thu, 20 March 2014 07:29
By: cookiemonster
  pls 00103 error
11g,toad 12.1
By: ashwanth77 on Thu, 20 March 2014
3 205 Thu, 20 March 2014 04:15
By: Michel Cadot
  How to use application tracing in oracle
By: aaditya321 on Wed, 19 March 2014
21 786 Thu, 20 March 2014 02:43
By: Michel Cadot
  Writing SQL Query
Oracle
By: rlsublime on Wed, 19 March 2014
1 221 Wed, 19 March 2014 19:30
By: BlackSwan
  Doubt with Associative Arrays
Oracle 9i, Solaris 10 Operating System
By: akull on Wed, 19 March 2014
8 524 Wed, 19 March 2014 17:15
By: ThomasG
  Replace Date column to Varchar Value
Windows
By: amit_jha05 on Tue, 18 March 2014
19 729 Wed, 19 March 2014 12:37
By: joy_division
  Rename Tablespace
Oracle 11.2.0.3.0 ,Linux
By: Jack14 on Tue, 18 March 2014
9 524 Wed, 19 March 2014 12:23
By: Michel Cadot
  Data validation in staging table
By: anujindia12 on Wed, 19 March 2014
9 566 Wed, 19 March 2014 10:14
By: John Watson
  string to number conversion
oracle 11g
By: meeplsql on Wed, 19 March 2014
10 516 Wed, 19 March 2014 08:44
By: Michel Cadot
  Difference between share & Exclusive Locks
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Wed, 19 March 2014
5 382 Wed, 19 March 2014 08:36
By: Michel Cadot
  I Object to that Cursor record!
PL/SQL 11G R2 Database Packages
By: msheda on Mon, 17 March 2014
7 575 Wed, 19 March 2014 08:13
By: msheda
  how to find data using date as a parameter in financial year
By: jgjeetu on Wed, 19 March 2014
1 203 Wed, 19 March 2014 05:54
By: cookiemonster
  SQL solution needed - urgent!
By: Annie Agarwal on Tue, 18 March 2014
14 796 Wed, 19 March 2014 04:36
By: cookiemonster
  timestamp shows 0 for all the records
11g,toad 12.1
By: ashwanth77 on Tue, 18 March 2014
6 456 Wed, 19 March 2014 04:17
By: cookiemonster
  Query taking Too much time
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
By: naveen_erp on Wed, 19 March 2014
1 262 Wed, 19 March 2014 00:08
By: BlackSwan
  Adding spaces to the column value
By: callmevj on Tue, 18 March 2014
9 532 Tue, 18 March 2014 15:01
By: Michel Cadot
  Help with grouping documents
Oracle 10g
By: krajesiu on Tue, 18 March 2014
4 356 Tue, 18 March 2014 08:16
By: Michel Cadot
  How to update the foreign key table
By: mist598 on Tue, 18 March 2014
16 724 Tue, 18 March 2014 06:42
By: mist598
  ORA-06504: PL/SQL: Return types of Result Set variables or query do not match
By: mist598 on Tue, 18 March 2014
8 578 Tue, 18 March 2014 03:07
By: mist598
  PL/SQL SYS_REFCURSOR Missing Data
Oracle Database 11g Enterprise Edition, 11.2.0.3.0, Windows Server 2003
By: annagel on Mon, 17 March 2014
6 398 Tue, 18 March 2014 01:05
By: Michel Cadot
  Instance Sequence Priority Values
Oracle 11g
By: developer12 on Mon, 17 March 2014
8 438 Mon, 17 March 2014 11:21
By: Michel Cadot
  merge 2 rows
pl sql
By: yesh on Mon, 17 March 2014
2 238 Mon, 17 March 2014 11:06
By: LKBrwn_DBA
  AutoCommit in Stored Proc
oracle 11g
By: feroze on Thu, 13 March 2014
5 564 Mon, 17 March 2014 08:25
By: cookiemonster
  File/Folder write permission in Oracle via Java Policy
Oracle 11g
By: didiera123 on Fri, 14 March 2014
2 404 Mon, 17 March 2014 00:36
By: didiera123
  PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
Oracle 10g
By: rvsri on Sun, 16 March 2014
5 702 Sun, 16 March 2014 09:47
By: BlackSwan
  How to do parallel inserts without changing table parallel degree
Oracle Database 11.2.0.3 Enterprise Edition
By: manubatham20 on Fri, 14 March 2014
2 337 Sun, 16 March 2014 02:41
By: John Watson
  Unknown number for looping-Logic
10g
By: dev1983 on Fri, 14 March 2014
3 436 Sat, 15 March 2014 18:21
By: dev1983
  Jpublisher is giving error while generating the class ? ? ?
By: rameshbandari777@gmail.co on Fri, 14 March 2014
1 208 Fri, 14 March 2014 12:09
By: Michel Cadot
  Oracle
Oracle 11g
By: amit_jha05 on Thu, 13 March 2014
16 880 Fri, 14 March 2014 11:23
By: ThomasG
  Efficient way to replace HTML codes with special characters
11.2.0.4
By: realspirituals on Fri, 14 March 2014
2 387 Fri, 14 March 2014 09:54
By: ThomasG
  DECODE
Oracle,8.1.7.0.0,Windows 2003 Server
By: kumarvk on Thu, 13 March 2014
5 516 Fri, 14 March 2014 08:22
By: Bill B
  store and read xml file in an oracle table
oracle11g , r2 , unix
By: rrnsamy@gmail.com on Fri, 14 March 2014
5 425 Fri, 14 March 2014 03:02
By: balaji123
  how to call package using persistant package variable
By: prasad2979 on Fri, 07 March 2014
8 747 Thu, 13 March 2014 23:49
By: vslabs
  Calc elapsed time within a group of data
10.2
By: lott42 on Thu, 13 March 2014
3 397 Thu, 13 March 2014 15:14
By: lott42
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 Aug 29 19:21:12 CDT 2014

Total time taken to generate the page: 0.19820 seconds