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
  Global variable
oracle 6i
By: HARSHAL.HVJ on Thu, 04 September 2014
4 262 Thu, 04 September 2014 05:39
By: Michel Cadot
  how to create database link
By: bikash karan on Thu, 18 November 2004
3 13356 Thu, 04 September 2014 02:28
By: Lalit Kumar B
  How to count working day
By: aaditya321 on Wed, 03 September 2014
11 459 Thu, 04 September 2014 01:40
By: aaditya321
  pragma autonomous
plsql
By: cool06prashant on Wed, 03 September 2014
5 190 Wed, 03 September 2014 15:44
By: Bill B
  SQL Query
Oracle 10g
By: vino06cse57 on Tue, 02 September 2014
4 360 Wed, 03 September 2014 11:59
By: Solomon Yakobson
  Find missing sequence number between given range
By: mayur.shinde511@gmail.com on Wed, 03 September 2014
11 352 Wed, 03 September 2014 03:59
By: mayur.shinde511@gmail.com
  Oracle sql query to pick current and previous records
Oracle, 11g, Windows
By: surestce on Mon, 01 September 2014
8 616 Tue, 02 September 2014 15:13
By: Michel Cadot
  Issue getting all data using WITH clause
By: carswelljr on Mon, 01 September 2014
10 449 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 338 Tue, 02 September 2014 07:16
By: Lalit Kumar B
  How to calculate exact age
Oracle
By: qanita786 on Fri, 21 October 2011
30 5188 Tue, 02 September 2014 06:37
By: Michel Cadot
  How works add column to table
linux
By: tazcox on Mon, 01 September 2014
8 415 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 406 Mon, 01 September 2014 00:34
By: jgjeetu
  Create view in PLSQL
Oracle 10g
By: kmuthu on Fri, 29 August 2014
6 372 Mon, 01 September 2014 00:03
By: Littlefoot
  char datatype - ora-01722
By: narang79 on Fri, 29 August 2014
13 440 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 240 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 302 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 417 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 2905 Fri, 29 August 2014 03:15
By: cookiemonster
  insert a character within a string
pl sql
By: deahayes3 on Thu, 28 August 2014
13 620 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 495 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 410 Thu, 28 August 2014 10:19
By: sss111ind
  Analytical Query AVG for different days in same sql
Oracle 10g/11g
By: raopatwariyahoocom on Thu, 28 August 2014
6 226 Thu, 28 August 2014 09:40
By: raopatwariyahoocom
  Query to display string in vertical form
By: PavanKumar on Thu, 27 April 2006
22 1937 Thu, 28 August 2014 05:54
By: Lalit Kumar B
  Find UPPER Chars in a name column
11g
By: Yuvraaj on Tue, 26 August 2014
8 419 Wed, 27 August 2014 00:54
By: Michel Cadot
  Code Convertions to Oracle 7.3.4
Oracle 7.3.4
By: saiphani723 on Wed, 27 August 2014
1 172 Wed, 27 August 2014 00:51
By: Michel Cadot
  select data using partition by clause where value of column is max
oracle 10g
By: jgjeetu on Mon, 25 August 2014
8 507 Tue, 26 August 2014 11:24
By: Michel Cadot
  Sql Satement with is null
11g Linux
By: preet_kumar on Tue, 26 August 2014
20 662 Tue, 26 August 2014 08:55
By: John Watson
  Use of /*All*/ or /*One*/ at the end of a Query
By: sread11 on Mon, 25 August 2014
4 261 Mon, 25 August 2014 14:48
By: Michel Cadot
  datatype of Null
PL SQL
By: smartkadhir on Sun, 24 August 2014
7 407 Sun, 24 August 2014 11:03
By: Lalit Kumar B
  exists data condition
By: mist598 on Thu, 21 August 2014
17 668 Fri, 22 August 2014 09:23
By: Lalit Kumar B
  using pivot
Oracle 11g
By: ora1980 on Thu, 21 August 2014
1 301 Thu, 21 August 2014 19:31
By: Barbara Boehmer
  fetching dynamic columns from a table
Oracle 11g
By: punitsoneji on Wed, 20 August 2014
17 804 Thu, 21 August 2014 14:07
By: Lalit Kumar B
  Help Required In - Row Generator Query
Oracle 11gR2, 11.2.0.1.0
By: jimit_shaili on Thu, 21 August 2014
6 294 Thu, 21 August 2014 06:31
By: Lalit Kumar B
  query
By: hany_marawan on Thu, 21 August 2014
2 165 Thu, 21 August 2014 03:05
By: hany_marawan
  SP2-0552: Bind variable "5" not declared.
Oracle 11.2.0.3 , Linux
By: Srijesh on Wed, 20 August 2014
19 635 Thu, 21 August 2014 00:56
By: Srijesh
  Row Count as End of the Row
Oracle 11g
By: Genesys on Wed, 20 August 2014
9 365 Wed, 20 August 2014 16:19
By: Bill B
  Compare and update Stored proc
By: deepugun on Wed, 20 August 2014
3 253 Wed, 20 August 2014 14:15
By: CraigB
  Table dependency for Audit tables
Oracle 11.2.0.3 , Linux
By: Srijesh on Wed, 20 August 2014
15 402 Wed, 20 August 2014 10:32
By: EdStevens
  How to find cardinality of a table in oracle
By: aaditya321 on Tue, 19 August 2014
17 508 Wed, 20 August 2014 07:26
By: aaditya321
  Retrieve one transaction which has max Net Sales in that day for 1 year and display by date
By: dwhasini@gmail.com on Tue, 19 August 2014
2 220 Tue, 19 August 2014 15:03
By: Michel Cadot
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: Thu Oct 02 05:36:29 CDT 2014

Total time taken to generate the page: 0.07212 seconds