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
  condition basis where clause
oracle 10 G
By: simplesanju on Tue, 09 September 2014
2 339 Tue, 09 September 2014 03:29
By: simplesanju
  ORDER BY gives good performance or INDEX hint gives good performance.
Oracle 11g
By: ramya_162 on Mon, 08 September 2014
3 645 Mon, 08 September 2014 07:31
By: EdStevens
  To log the row in error while selecting from database
Oracle 10g
By: gopal.biswal on Sun, 07 September 2014
8 468 Mon, 08 September 2014 03:14
By: cookiemonster
  Getting only the first occurrence of the sub string in the given string
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionE
By: saipradyumn on Fri, 05 September 2014
12 773 Mon, 08 September 2014 00:29
By: saipradyumn
  Show only one of the duplicate values ​​in a column
By: hahaie on Sun, 07 September 2014
5 339 Sun, 07 September 2014 23:09
By: BlackSwan
  Exception : No data
Oracle 11g
By: Oracle_Walker on Thu, 04 September 2014
13 636 Sun, 07 September 2014 04:19
By: Littlefoot
  Compare values between two different tables
11g
By: haadiya on Sat, 06 September 2014
7 542 Sat, 06 September 2014 09:04
By: Lalit Kumar B
icon8.gif ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 , Linux s600986dc3sl04.clouddb.savvis.net 2.6.18-194.17.1.el5 #
By: manishdba007 on Sat, 06 September 2014
4 704 Sat, 06 September 2014 03:26
By: manishdba007
  Problem in Insersion
SQL, 11g Release 11.2.0.2.0 ,Win7
By: shumail on Fri, 05 September 2014
2 522 Fri, 05 September 2014 14:00
By: shumail
  How to escape '
By: maitequita on Fri, 05 September 2014
5 393 Fri, 05 September 2014 13:02
By: Bill B
  Insertion logic
By: shumail on Fri, 05 September 2014
4 246 Fri, 05 September 2014 11:30
By: shumail
  Want to create View with parameter
Oracle 11G
By: hemant_khandare on Wed, 03 September 2014
5 476 Fri, 05 September 2014 10:28
By: Michel Cadot
  Round values to 0,5,10,100 ..
Oracle 10G r2
By: mmohsinaziz on Fri, 05 September 2014
4 504 Fri, 05 September 2014 04:38
By: mmohsinaziz
  need to find exception line no inside procedure of 1000 lines.
Oracle 11G
By: hemant_khandare on Wed, 03 September 2014
8 539 Fri, 05 September 2014 04:16
By: Lalit Kumar B
  Recover rows after delete and commit
Oracle 11G
By: hemant_khandare on Wed, 03 September 2014
6 539 Fri, 05 September 2014 03:48
By: hemant_khandare
  Update trigger (merged 2)
ORACLE FORMS 6i ,WINDOW 7 ULTIMATE(32),11G database R2
By: kilimanjaro on Sat, 23 August 2014
5 502 Fri, 05 September 2014 01:22
By: kilimanjaro
  ORA-29279: SMTP permanent error: Unable to relay
Oracle 10g
By: sarfarazahmedv on Tue, 16 August 2011
10 22562 Thu, 04 September 2014 14:33
By: Solomon Yakobson
  Advantages of Order of Tables in "FROM " Clause
By: mastansky@gmail.com on Thu, 04 September 2014
6 438 Thu, 04 September 2014 10:29
By: Michel Cadot
  CHMOD FROM A PLSQL?
By: satishvaka on Mon, 01 September 2014
5 568 Thu, 04 September 2014 09:06
By: BlackSwan
icon5.gif Problem while Modifying column data type
By: mastansky@gmail.com on Thu, 04 September 2014
2 511 Thu, 04 September 2014 07:15
By: mastansky@gmail.com
  Global variable
oracle 6i
By: HARSHAL.HVJ on Thu, 04 September 2014
4 437 Thu, 04 September 2014 05:39
By: Michel Cadot
  how to create database link
By: bikash karan on Thu, 18 November 2004
3 15175 Thu, 04 September 2014 02:28
By: Lalit Kumar B
  pragma autonomous
plsql
By: cool06prashant on Wed, 03 September 2014
5 380 Wed, 03 September 2014 15:44
By: Bill B
  SQL Query
Oracle 10g
By: vino06cse57 on Tue, 02 September 2014
4 580 Wed, 03 September 2014 11:59
By: Solomon Yakobson
  Find missing sequence number between given range
By: Mayur Shinde on Wed, 03 September 2014
11 562 Wed, 03 September 2014 03:59
By: Mayur Shinde
  Oracle sql query to pick current and previous records
Oracle, 11g, Windows
By: surestce on Mon, 01 September 2014
8 923 Tue, 02 September 2014 15:13
By: Michel Cadot
  Issue getting all data using WITH clause
By: carswelljr on Mon, 01 September 2014
10 613 Tue, 02 September 2014 15:06
By: BlackSwan
  Calender from 1-Jan-0001 Till 31-Dec-9999
By: mastansky@gmail.com on Tue, 02 September 2014
7 830 Tue, 02 September 2014 07:16
By: Lalit Kumar B
  How to calculate exact age
Oracle
By: qanita786 on Fri, 21 October 2011
30 6675 Tue, 02 September 2014 06:37
By: Michel Cadot
  How works add column to table
linux
By: tazcox on Mon, 01 September 2014
8 634 Mon, 01 September 2014 08:37
By: Michel Cadot
  SQL to calculate call cost for varying time durations
ORACLE 10G
By: jgjeetu on Fri, 29 August 2014
9 629 Mon, 01 September 2014 00:34
By: jgjeetu
  Create view in PLSQL
Oracle 10g
By: kmuthu on Fri, 29 August 2014
6 573 Mon, 01 September 2014 00:03
By: Littlefoot
  char datatype - ora-01722
By: narang79 on Fri, 29 August 2014
13 682 Sat, 30 August 2014 05:34
By: Lalit Kumar B
  Re : Email with Attachment Body content not coming
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
By: shanmugait on Fri, 29 August 2014
1 563 Fri, 29 August 2014 10:43
By: Michel Cadot
  Excel created using utl_file is larger than manual file creation
Oracle apps 12.1.1 (11g)
By: shanmugait on Fri, 29 August 2014
5 578 Fri, 29 August 2014 05:55
By: cookiemonster
  How to get warnings for implicit type conversions?
SQLDeveloper 3.1.07/Oracle 11.1.0.1/Linux
By: Justin Schoeman on Thu, 28 August 2014
11 673 Fri, 29 August 2014 03:47
By: Justin Schoeman
  First business day of a given month
Oracle 10g
By: sidh_z on Mon, 06 December 2010
20 3461 Fri, 29 August 2014 03:15
By: cookiemonster
  insert a character within a string
pl sql
By: deahayes3 on Thu, 28 August 2014
13 832 Fri, 29 August 2014 02:53
By: cookiemonster
  Invalid reference to variable, ORA-22806: not an object or REF
Toad 10.1.6.3
By: lvrvln on Thu, 28 August 2014
8 919 Thu, 28 August 2014 13:35
By: Michel Cadot
  update a table based on another table with no specific order
Oracle 10g
By: sss111ind on Thu, 28 August 2014
23 593 Thu, 28 August 2014 10:19
By: sss111ind
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 May 30 00:25:45 CDT 2015

Total time taken to generate the page: 0.12359 seconds