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 404 Wed, 10 February 2016 15:33
By: BlackSwan
  SQL query help
Oracle 11g
By: nsankineni on Tue, 09 February 2016
3 437 Wed, 10 February 2016 02:48
By: cookiemonster
  Row lock without blocker
By: gajini on Tue, 09 February 2016
9 449 Tue, 09 February 2016 11:59
By: Bill B
  Insertion error
forms6i, oracle 10g
By: snsiddiqui on Mon, 08 February 2016
6 658 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 516 Mon, 08 February 2016 08:01
By: Bill B
  Data Chucking based on Timewindow
By: razasheikh on Sat, 06 February 2016
10 639 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 724 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 407 Sun, 07 February 2016 09:46
By: BlackSwan
  help with a query
Oracle sql
By: zoe2003 on Sun, 07 February 2016
1 283 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 739 Sat, 06 February 2016 16:04
By: EdStevens
  Variables
sql
By: M123 on Thu, 04 February 2016
4 390 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 2193 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 756 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 1034 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 3667 Tue, 02 February 2016 11:11
By: Solomon Yakobson
  Missing Day data
Oracle SQl
By: razasheikh on Mon, 01 February 2016
6 2707 Tue, 02 February 2016 04:18
By: Michel Cadot
  Regarding row lock
oracle 12c
By: gorants on Tue, 26 January 2016
21 1441 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 841 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 646 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 987 Wed, 27 January 2016 16:16
By: Barbara Boehmer
  Determine Missing Route_Seq Numbers
Oracle 11g
By: stun66 on Tue, 26 January 2016
5 1081 Wed, 27 January 2016 05:55
By: Solomon Yakobson
  SQL QUERY HELP
By: arifs3738 on Wed, 27 January 2016
2 950 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 301 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 736 Mon, 25 January 2016 07:04
By: quirks
  help to make sql query
sql
By: deepak416 on Sun, 24 January 2016
3 541 Sun, 24 January 2016 07:54
By: Solomon Yakobson
  Interval Partitioning and local index
By: menoarc on Sat, 23 January 2016
6 409 Sun, 24 January 2016 04:47
By: menoarc
  INSERT into a Partition
By: tony_soprano786 on Fri, 22 January 2016
3 420 Fri, 22 January 2016 09:32
By: Michel Cadot
  separate string by comma
Oracle 11g
By: mape on Wed, 20 January 2016
4 594 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 508 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 397 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 420 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 406 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 654 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 4529 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 662 Tue, 19 January 2016 03:11
By: Michel Cadot
  CHAR '
ORACLE 6i
By: NNAAEE on Thu, 14 January 2016
11 512 Mon, 18 January 2016 08:38
By: EdStevens
  SQL Query
Oracle 10g
By: swapnil_naik on Mon, 18 January 2016
6 342 Mon, 18 January 2016 04:24
By: Michel Cadot
  ANSI SQL STATEMENTS
By: Danny Freeman on Fri, 15 January 2016
3 559 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 821 Sat, 16 January 2016 06:56
By: Solomon Yakobson
  interview question
oracle 10g
By: san-deep on Fri, 15 January 2016
5 559 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: Tue May 24 05:27:49 CDT 2016

Total time taken to generate the page: 0.12937 seconds