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
  unrelated procedure goes invalid
Oracle 11.2.0.2.0, Solaris
By: uman2631 on Wed, 17 February 2016
1 439 Wed, 17 February 2016 16:06
By: BlackSwan
  External table error
By: techgirl123 on Wed, 24 February 2016
2 629 Wed, 24 February 2016 12:43
By: Barbara Boehmer
  Retrieve specified characters from LONG datatype
Oracle 11.2.0.4, Windows x64
By: MurraySobol on Tue, 16 February 2016
4 677 Thu, 18 February 2016 09:52
By: Michel Cadot
  Minus query with string values (merged)
By: Devmunat on Tue, 16 February 2016
3 710 Thu, 18 February 2016 02:11
By: Devmunat
  Getting Desire Data According to the interval...
Oracle 11g, Windows 2008 R2....
By: Dips99 on Tue, 16 February 2016
5 665 Wed, 17 February 2016 03:05
By: Michel Cadot
  using index and cursor
4.1.3 sql developer
By: M123 on Mon, 15 February 2016
11 873 Wed, 17 February 2016 02:12
By: JNagtzaam
  Queries for User and Password Policy
Oracle DB 11g
By: fanigadu20 on Mon, 15 February 2016
3 456 Mon, 15 February 2016 14:56
By: Bill B
  Scheduling job at 6 am and 7.30 pm
Oracle 10g
By: sss111ind on Wed, 17 February 2016
7 685 Thu, 18 February 2016 06:09
By: sss111ind
  retrieve first changed row
By: suji6281 on Mon, 15 February 2016
35 2003 Fri, 26 February 2016 01:48
By: varlamovvp
  What is the switching context with FORALL?
Oracle 11gr2
By: Ikebukuro on Sun, 14 February 2016
1 445 Sun, 14 February 2016 11:08
By: BlackSwan
  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 685 Wed, 10 February 2016 15:33
By: BlackSwan
  query start_date and end_Date
windows Server 2008 r2
By: Dips99 on Sun, 14 February 2016
6 738 Wed, 17 February 2016 15:54
By: Bill B
  Materialised view refresh on commit
Oracle 10.2.0.4.0
By: brown_zzz on Thu, 11 February 2016
1 565 Thu, 11 February 2016 07:48
By: John Watson
  Can any one help to remove duplicate rows in a table
11.1.0.7
By: kerneltraining on Thu, 11 February 2016
3 791 Fri, 12 February 2016 07:22
By: Bill B
  truncating a empty table
11g
By: arudesai on Tue, 09 February 2016
19 4884 Mon, 15 February 2016 02:07
By: Roachcoach
  SQL query help
Oracle 11g
By: nsankineni on Tue, 09 February 2016
3 696 Wed, 10 February 2016 02:48
By: cookiemonster
icon5.gif using case when ..need suggestion
4.1.3 sql developer
By: M123 on Tue, 09 February 2016
26 1558 Wed, 10 February 2016 17:23
By: M123
icon5.gif update using with statement
Oracle 11.2 on Windows 8.1
By: fhsmagna on Tue, 09 February 2016
8 3038 Thu, 18 February 2016 07:48
By: gazzag
  Row lock without blocker
By: gajini on Tue, 09 February 2016
9 719 Tue, 09 February 2016 11:59
By: Bill B
  Compound Trigger
Oracle 11g, Windows NT
By: pstanand on Wed, 23 March 2016
5 705 Wed, 23 March 2016 15:16
By: Bill B
  Insertion error
forms6i, oracle 10g
By: snsiddiqui on Mon, 08 February 2016
6 946 Tue, 09 February 2016 02:40
By: Michel Cadot
  help with a query
Oracle sql
By: zoe2003 on Sun, 07 February 2016
1 415 Sun, 07 February 2016 08:34
By: John Watson
  diffrence between stored procedure and package preocdures
oracle plsql
By: kasi7890 on Sun, 07 February 2016
4 620 Sun, 07 February 2016 09:46
By: BlackSwan
  wrong argument passed any suggestion
4.1.3 sql developer
By: M123 on Sat, 06 February 2016
9 807 Mon, 08 February 2016 08:01
By: Bill B
  Data Chucking based on Timewindow
By: razasheikh on Sat, 06 February 2016
10 869 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 1154 Sun, 07 February 2016 19:31
By: EdStevens
  Variables
sql
By: M123 on Thu, 04 February 2016
4 680 Thu, 04 February 2016 19:17
By: M123
  How to use DISTINCT for CLOB data type?
Oracle 11g
By: Oracle_Walker on Thu, 28 January 2016
4 1289 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 3985 Tue, 02 February 2016 11:11
By: Solomon Yakobson
  change permanently the value of the initialization parameter
Oracle
By: Nagaram on Thu, 04 February 2016
4 2461 Thu, 04 February 2016 16:30
By: Barbara Boehmer
  SQL QUERY HELP
By: arifs3738 on Wed, 27 January 2016
2 1082 Wed, 27 January 2016 03:24
By: John Watson
  Regarding row lock
oracle 12c
By: gorants on Tue, 26 January 2016
21 1824 Sun, 31 January 2016 19:21
By: gorants
  Determine Missing Route_Seq Numbers
Oracle 11g
By: stun66 on Tue, 26 January 2016
5 1270 Wed, 27 January 2016 05:55
By: Solomon Yakobson
  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 1268 Fri, 29 January 2016 16:04
By: Bill B
  Comma separated column values matching
10.0.0.1
By: pratik4891 on Thu, 04 February 2016
20 1062 Thu, 04 February 2016 16:25
By: Barbara Boehmer
  How to get the first less date than agiven date in sql
By: blyzz on Tue, 26 January 2016
2 562 Tue, 26 January 2016 12:04
By: Barbara Boehmer
icon5.gif UTL_FILE Writeing in multiple text files
Oracle SQL Developer
By: thsankar on Tue, 26 January 2016
21 1265 Fri, 29 January 2016 21:49
By: thsankar
  Need to convert into date for differernt kind of formates
Oracle 11g
By: saipradyumn on Mon, 25 January 2016
13 1035 Sat, 06 February 2016 16:04
By: EdStevens
  Interval Partitioning and local index
By: menoarc on Sat, 23 January 2016
6 690 Sun, 24 January 2016 04:47
By: menoarc
  help to make sql query
sql
By: deepak416 on Sun, 24 January 2016
3 761 Sun, 24 January 2016 07:54
By: Solomon Yakobson
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 Oct 16 21:14:56 CDT 2017

Total time taken to generate the page: 0.01702 seconds