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
  Why this happens with Recyclebin in Oracle
Oracle DB, 10g R2, Windows server 2008 R2
By: mdsirajoddin on Wed, 24 February 2016
7 428 Wed, 24 February 2016 11:20
By: Michel Cadot
  ORA-00600: internal error code
forms 6i and database 10g win xp
By: alshadbik on Tue, 23 February 2016
7 464 Wed, 24 February 2016 07:59
By: Littlefoot
icon5.gif General question about temporary tables
Oracle 11GR2, WIN Server 2008
By: OlafCologne on Wed, 24 February 2016
2 379 Wed, 24 February 2016 06:43
By: Michel Cadot
  Re: Return ColumnNames in lowercase. (split from highjacked thread http://www.orafaq.com/forum/t/175479/0/unread/#msg_648450 by bb)
By: sss111ind on Tue, 23 February 2016
11 426 Wed, 24 February 2016 02:52
By: sss111ind
  ORA-00001: unique constraint (UNKNOWN.obj#=179690) violated
Oracle11G EE
By: famegaurav on Thu, 05 February 2015
7 1863 Wed, 24 February 2016 01:00
By: Michel Cadot
  Ref cursor ?
4.1.3 sql developer
By: M123 on Mon, 22 February 2016
3 360 Tue, 23 February 2016 17:57
By: M123
  quoting string in multiple lines
Oracle 11.2.0.3
By: pointers on Fri, 19 February 2016
5 726 Tue, 23 February 2016 01:58
By: pointers
  Join 2 select statements
Oracle 11203, Windows
By: kar116 on Tue, 23 February 2016
1 360 Tue, 23 February 2016 00:58
By: Michel Cadot
  Indexing advice
11g R2
By: geordibbk on Fri, 19 February 2016
6 500 Mon, 22 February 2016 13:10
By: Bill B
  How to use LAG function in oracle pl sql until non zero value is reached?
oracle pl sql
By: adfire on Sat, 20 February 2016
4 475 Mon, 22 February 2016 12:55
By: Michel Cadot
  initialize a nested table
Oracle11gR2, windows 7
By: live4learn on Sat, 20 February 2016
3 619 Mon, 22 February 2016 00:57
By: _jum
  data view
sql+
By: vishnuy on Sun, 21 February 2016
2 297 Sun, 21 February 2016 14:04
By: cookiemonster
  filtering in a table by ignoring the records those are unnecessary anymore
oracle sql developer 4.1.3.20
By: gujarati on Sat, 20 February 2016
6 476 Sat, 20 February 2016 13:27
By: Michel Cadot
  Query
11g
By: glmjoy on Fri, 19 February 2016
5 624 Sat, 20 February 2016 06:32
By: Solomon Yakobson
  Oracle Dates query
ORACLE, 12.1.0.2.0, WINDOWS 10
By: anil_mk on Fri, 19 February 2016
12 430 Fri, 19 February 2016 11:54
By: Michel Cadot
  Access variables from different script
Oracle 11.2.0.2
By: pointers on Fri, 19 February 2016
2 395 Fri, 19 February 2016 06:49
By: pointers
  Sql Query between String
By: sumit.cse07 on Thu, 18 February 2016
3 389 Thu, 18 February 2016 11:04
By: Michel Cadot
  Retrieve specified characters from LONG datatype
Oracle 11.2.0.4, Windows x64
By: MurraySobol on Tue, 16 February 2016
4 510 Thu, 18 February 2016 09:52
By: Michel Cadot
icon5.gif update using with statement
Oracle 11.2 on Windows 8.1
By: fhsmagna on Tue, 09 February 2016
8 1544 Thu, 18 February 2016 07:48
By: gazzag
  Scheduling job at 6 am and 7.30 pm
Oracle 10g
By: sss111ind on Wed, 17 February 2016
7 506 Thu, 18 February 2016 06:09
By: sss111ind
  Minus query with string values (merged)
By: Devmunat on Tue, 16 February 2016
3 570 Thu, 18 February 2016 02:11
By: Devmunat
  unrelated procedure goes invalid
Oracle 11.2.0.2.0, Solaris
By: uman2631 on Wed, 17 February 2016
1 277 Wed, 17 February 2016 16:06
By: BlackSwan
  query start_date and end_Date
windows Server 2008 r2
By: Dips99 on Sun, 14 February 2016
6 550 Wed, 17 February 2016 15:54
By: Bill B
  View tailoring
By: geordibbk on Thu, 07 January 2016
7 842 Wed, 17 February 2016 15:39
By: Bill B
  Getting Desire Data According to the interval...
Oracle 11g, Windows 2008 R2....
By: Dips99 on Tue, 16 February 2016
5 472 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 633 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 350 Mon, 15 February 2016 14:56
By: Bill B
  truncating a empty table
11g
By: arudesai on Tue, 09 February 2016
19 4590 Mon, 15 February 2016 02:07
By: Roachcoach
  What is the switching context with FORALL?
Oracle 11gr2
By: Ikebukuro on Sun, 14 February 2016
1 326 Sun, 14 February 2016 11:08
By: BlackSwan
  Can any one help to remove duplicate rows in a table
11.1.0.7
By: kerneltraining on Thu, 11 February 2016
3 650 Fri, 12 February 2016 07:22
By: Bill B
  Materialised view refresh on commit
Oracle 10.2.0.4.0
By: brown_zzz on Thu, 11 February 2016
1 462 Thu, 11 February 2016 07:48
By: John Watson
icon5.gif using case when ..need suggestion
4.1.3 sql developer
By: M123 on Tue, 09 February 2016
26 1029 Wed, 10 February 2016 17:23
By: M123
  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 470 Wed, 10 February 2016 15:33
By: BlackSwan
  SQL query help
Oracle 11g
By: nsankineni on Tue, 09 February 2016
3 500 Wed, 10 February 2016 02:48
By: cookiemonster
  Row lock without blocker
By: gajini on Tue, 09 February 2016
9 512 Tue, 09 February 2016 11:59
By: Bill B
  Insertion error
forms6i, oracle 10g
By: snsiddiqui on Mon, 08 February 2016
6 724 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 570 Mon, 08 February 2016 08:01
By: Bill B
  Data Chucking based on Timewindow
By: razasheikh on Sat, 06 February 2016
10 705 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 818 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 474 Sun, 07 February 2016 09:46
By: BlackSwan
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 Sep 27 02:18:41 CDT 2016

Total time taken to generate the page: 0.19473 seconds