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
  Update Statement
Oracle 11g
By: srinivas.k2005 on Mon, 03 February 2014
11 514 Mon, 03 February 2014 12:07
By: Solomon Yakobson
  How to send mail from an Oracle database?
By: anncao on Mon, 03 February 2014
1 231 Mon, 03 February 2014 11:22
By: BlackSwan
  SQL Query Scenario
Oracle 10g
By: vino06cse57 on Mon, 03 February 2014
5 312 Mon, 03 February 2014 08:56
By: Michel Cadot
  datatype
oracle 9i
By: DUTTA@TARUN on Sun, 02 February 2014
8 437 Mon, 03 February 2014 06:01
By: Michel Cadot
  copy table data to other table
By: xWarriors on Mon, 03 February 2014
2 272 Mon, 03 February 2014 03:08
By: manigdv
  Substring on digit in a character expression gives ORA-1722
Oracle 11.1.0.7.0
By: Andrey_R on Sun, 02 February 2014
10 1160 Mon, 03 February 2014 02:21
By: Andrey_R
  ALL,ANY,SOME operators
By: Rajesh@ on Mon, 03 February 2014
7 320 Mon, 03 February 2014 01:37
By: Michel Cadot
  seperate out the string occured between particular characters
Oracle 11g, Win7
By: nischalinn on Thu, 23 January 2014
6 487 Mon, 03 February 2014 00:54
By: Littlefoot
  ORA-00923: FROM keyword not found where expected error
By: Rajesh@ on Sun, 02 February 2014
3 439 Sun, 02 February 2014 23:45
By: BlackSwan
  Synonym - DB link
By: yesh on Sun, 02 February 2014
4 487 Sun, 02 February 2014 11:03
By: Littlefoot
  How create the table with begin and end
By: vik@s on Mon, 27 January 2014
4 656 Sun, 02 February 2014 04:01
By: Michel Cadot
icon5.gif Identify invalid number in exception handler
Oracle 11g,Window 2008, using Toad
By: jxh461 on Thu, 30 January 2014
6 729 Sun, 02 February 2014 03:46
By: Michel Cadot
  dynamic sql
oracle 11g
By: guddu_12 on Fri, 31 January 2014
2 453 Sun, 02 February 2014 03:46
By: shahnirav86
  Simple Query
By: Shazin on Sat, 01 February 2014
17 841 Sat, 01 February 2014 14:26
By: BlackSwan
  How to find day of the week, starting with Monday
By: aaditya321 on Sat, 01 February 2014
6 536 Sat, 01 February 2014 14:22
By: manubatham20
  Run Print cmd through plsql
Oracle 10g Windows2003
By: sunilreddy on Fri, 31 January 2014
10 553 Sat, 01 February 2014 11:13
By: Michel Cadot
  where is oracle built in package stored
oracle 11g.2 , windows
By: anncao on Fri, 31 January 2014
4 390 Sat, 01 February 2014 11:13
By: Michel Cadot
icon2.gif Formatting html file for an explain plan
By: Malakay79 on Sat, 01 February 2014
1 194 Sat, 01 February 2014 08:21
By: Michel Cadot
icon5.gif Send file to client
9g
By: Lalilulelo on Thu, 30 January 2014
2 416 Fri, 31 January 2014 15:27
By: Lalilulelo
  Tablename as input parameter
By: sarma.shp on Wed, 29 January 2014
4 406 Fri, 31 January 2014 11:00
By: Michel Cadot
  Remove special characters
By: quteboycmg@gmail.com on Fri, 31 January 2014
1 287 Fri, 31 January 2014 05:09
By: Littlefoot
  procedure out parameter
oracle 10g
By: vivek_rol on Thu, 30 January 2014
2 241 Fri, 31 January 2014 00:58
By: Michel Cadot
  exceptions
By: nataliafoster26 on Fri, 24 January 2014
4 402 Thu, 30 January 2014 22:24
By: Kevin Meade
  Row number for null
10g
By: mamalik on Thu, 30 January 2014
9 873 Thu, 30 January 2014 14:47
By: Michel Cadot
  creation_date should be equal to update_date
By: mist598 on Wed, 29 January 2014
15 569 Thu, 30 January 2014 11:41
By: Lalit Kumar B
icon1.gif exam seating plan & datesheet
win 8
By: shekhar786 on Thu, 30 January 2014
1 282 Thu, 30 January 2014 10:39
By: pablolee
  How to store the table data(Backup)
By: mist598 on Thu, 30 January 2014
6 508 Thu, 30 January 2014 08:46
By: Lalit Kumar B
  PLS-00201: identifier 'EMPNO' must be declare
By: mist598 on Tue, 28 January 2014
17 1046 Thu, 30 January 2014 02:59
By: pablolee
  Convert date format for easier lookup
By: tdnguyen on Tue, 21 January 2014
5 509 Thu, 30 January 2014 01:23
By: subhra_88
  How to get back purged data into the tables
By: mist598 on Wed, 29 January 2014
18 645 Wed, 29 January 2014 14:18
By: John Watson
  Searching string with special characters using INSTR function
oracle 10g
By: babhuko on Wed, 29 January 2014
1 353 Wed, 29 January 2014 11:53
By: Michel Cadot
  Oracle Message - <pck name.proc name> : 301
9.2.0.8.0
By: grpatwari on Wed, 29 January 2014
5 267 Wed, 29 January 2014 10:53
By: grpatwari
  Can you any one help me to solve the unique constraint error
Oracle 11g
By: na.dharma@gmail.com on Wed, 29 January 2014
4 231 Wed, 29 January 2014 09:38
By: BlackSwan
  Selecting top records
Oracle 11g
By: KeithS on Tue, 28 January 2014
3 335 Wed, 29 January 2014 09:01
By: BlackSwan
  Restrictions in accessing collections values
Oracle 10g
By: anilkln on Wed, 29 January 2014
3 335 Wed, 29 January 2014 02:59
By: Michel Cadot
  Extracting sub-string in reverse way
SQL
By: hi.villinda on Tue, 28 January 2014
3 339 Tue, 28 January 2014 03:25
By: pablolee
  triggers
oracle 12c
By: danny432 on Mon, 27 January 2014
15 677 Mon, 27 January 2014 12:30
By: Michel Cadot
  Success event log
10.2
By: juhani on Fri, 24 January 2014
7 616 Mon, 27 January 2014 11:39
By: Kevin Meade
  what is the name of the sequence for my table
11.2g windows
By: anncao on Fri, 24 January 2014
12 738 Mon, 27 January 2014 10:36
By: pablolee
  optimize the query and store result in a variable
Oracle 11g, Win7
By: nischalinn on Fri, 24 January 2014
6 599 Mon, 27 January 2014 09:04
By: Kevin Meade
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: Sat Sep 20 19:27:55 CDT 2014

Total time taken to generate the page: 0.07520 seconds