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
  Not Exists vs Left Outer Join with NULL
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: manubatham20 on Wed, 10 February 2016
1 549 Wed, 10 February 2016 15:33
By: BlackSwan
  SQL query help
Oracle 11g
By: nsankineni on Tue, 09 February 2016
3 564 Wed, 10 February 2016 02:48
By: cookiemonster
  Row lock without blocker
By: gajini on Tue, 09 February 2016
9 593 Tue, 09 February 2016 11:59
By: Bill B
  Insertion error
forms6i, oracle 10g
By: snsiddiqui on Mon, 08 February 2016
6 810 Tue, 09 February 2016 02:40
By: Michel Cadot
  wrong argument passed any suggestion
4.1.3 sql developer
By: M123 on Sat, 06 February 2016
9 652 Mon, 08 February 2016 08:01
By: Bill B
  Data Chucking based on Timewindow
By: razasheikh on Sat, 06 February 2016
10 760 Mon, 08 February 2016 04:09
By: razasheikh
  Triggers based Q....ion
4.1.3 sql developer
By: M123 on Fri, 05 February 2016
16 895 Sun, 07 February 2016 19:31
By: EdStevens
  diffrence between stored procedure and package preocdures
oracle plsql
By: kasi7890 on Sun, 07 February 2016
4 536 Sun, 07 February 2016 09:46
By: BlackSwan
  help with a query
Oracle sql
By: zoe2003 on Sun, 07 February 2016
1 352 Sun, 07 February 2016 08:34
By: John Watson
  Need to convert into date for differernt kind of formates
Oracle 11g
By: saipradyumn on Mon, 25 January 2016
13 881 Sat, 06 February 2016 16:04
By: EdStevens
  Variables
sql
By: M123 on Thu, 04 February 2016
4 521 Thu, 04 February 2016 19:17
By: M123
  change permanently the value of the initialization parameter
Oracle
By: Nagaram on Thu, 04 February 2016
4 2321 Thu, 04 February 2016 16:30
By: Barbara Boehmer
  Comma separated column values matching
10.0.0.1
By: pratik4891 on Thu, 04 February 2016
20 886 Thu, 04 February 2016 16:25
By: Barbara Boehmer
  How to use DISTINCT for CLOB data type?
Oracle 11g
By: Oracle_Walker on Thu, 28 January 2016
4 1160 Thu, 04 February 2016 10:34
By: Oracle_Walker
  Updating duplicate records with different data
Oracle 11g
By: bhush5bhai on Mon, 01 February 2016
8 3836 Tue, 02 February 2016 11:11
By: Solomon Yakobson
  Missing Day data
Oracle SQl
By: razasheikh on Mon, 01 February 2016
6 2831 Tue, 02 February 2016 04:18
By: Michel Cadot
  Regarding row lock
oracle 12c
By: gorants on Tue, 26 January 2016
21 1645 Sun, 31 January 2016 19:21
By: gorants
icon5.gif UTL_FILE Writeing in multiple text files
Oracle SQL Developer
By: thsankar on Tue, 26 January 2016
21 1043 Fri, 29 January 2016 21:49
By: thsankar
  How can I pass UserId/Password securely as a parameter using UTL_HTTP
Oracle 11G Enterprise 11.2.0.4.0 - 64bit
By: kjcook on Tue, 26 January 2016
10 929 Fri, 29 January 2016 16:04
By: Bill B
icon5.gif How to capture particular column from select statement inside a package body in oracle pl sql
oracle pl sql
By: adfire on Fri, 15 January 2016
13 1165 Wed, 27 January 2016 16:16
By: Barbara Boehmer
  Determine Missing Route_Seq Numbers
Oracle 11g
By: stun66 on Tue, 26 January 2016
5 1163 Wed, 27 January 2016 05:55
By: Solomon Yakobson
  SQL QUERY HELP
By: arifs3738 on Wed, 27 January 2016
2 1039 Wed, 27 January 2016 03:24
By: John Watson
  How to get the first less date than agiven date in sql
By: blyzz on Tue, 26 January 2016
2 418 Tue, 26 January 2016 12:04
By: Barbara Boehmer
  Corrections with overlapping time frames (SOLVED)
Oracle 11
By: quirks on Wed, 20 January 2016
8 878 Mon, 25 January 2016 07:04
By: quirks
  help to make sql query
sql
By: deepak416 on Sun, 24 January 2016
3 673 Sun, 24 January 2016 07:54
By: Solomon Yakobson
  Interval Partitioning and local index
By: menoarc on Sat, 23 January 2016
6 557 Sun, 24 January 2016 04:47
By: menoarc
  INSERT into a Partition
By: tony_soprano786 on Fri, 22 January 2016
3 506 Fri, 22 January 2016 09:32
By: Michel Cadot
  separate string by comma
Oracle 11g
By: mape on Wed, 20 January 2016
4 702 Thu, 21 January 2016 16:28
By: Bill B
  Unable to pass 1st value into the query
Oracle, 11.2.0.4.0, Windows 7 Professional 64 bit
By: buggleboy007 on Tue, 19 January 2016
8 605 Wed, 20 January 2016 22:07
By: buggleboy007
  How To Get JV/34 as JV/0034 or JV/034 as JV/0034 or JV/0034 as JV/0034 using regular expression
By: jainarayan5484 on Wed, 20 January 2016
3 482 Wed, 20 January 2016 09:15
By: Solomon Yakobson
  db link between 10g and 12c
10g 12c
By: mshrkshl on Tue, 19 January 2016
4 829 Wed, 20 January 2016 04:25
By: Littlefoot
  Use cursor output in the IN CLAUSE
11.2.1.0
By: OraFerro on Tue, 19 January 2016
4 508 Tue, 19 January 2016 13:48
By: Barbara Boehmer
  ora-12096
Oracle 11.2.0.4, Windows 2008 R2
By: sant_new1 on Mon, 18 January 2016
22 835 Tue, 19 January 2016 13:32
By: sant_new1
  How do I find a value anywhere in a Oracle schema ?
12c
By: gorants on Mon, 18 January 2016
15 4900 Tue, 19 January 2016 10:08
By: gorants
  VARCHAR2 Convert to H:MI:SS tt (merged 2)
Windows server 2008r2
By: farrukh786 on Mon, 18 January 2016
28 790 Tue, 19 January 2016 03:11
By: Michel Cadot
  CHAR '
ORACLE 6i
By: NNAAEE on Thu, 14 January 2016
11 676 Mon, 18 January 2016 08:38
By: EdStevens
  SQL Query
Oracle 10g
By: swapnil_naik on Mon, 18 January 2016
6 418 Mon, 18 January 2016 04:24
By: Michel Cadot
  ANSI SQL STATEMENTS
By: Danny Freeman on Fri, 15 January 2016
3 743 Sun, 17 January 2016 08:26
By: Solomon Yakobson
  How to use minus, union for CLOB datatype column in Oracle?
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: Oracle_Walker on Thu, 14 January 2016
12 1104 Sat, 16 January 2016 06:56
By: Solomon Yakobson
  interview question
oracle 10g
By: san-deep on Fri, 15 January 2016
5 718 Fri, 15 January 2016 12:43
By: pablolee
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: Mon Jan 23 02:30:36 CST 2017

Total time taken to generate the page: 0.13014 seconds