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
  Query to find all records with either same value or null value
By: ranugupta3 on Thu, 25 February 2016
5 486 Thu, 25 February 2016 08:36
By: varlamovvp
  update statement using from clause
11.2.0.4, Windows 64-bit
By: MurraySobol on Thu, 18 February 2016
14 863 Thu, 25 February 2016 04:31
By: varlamovvp
  External table error
By: techgirl123 on Wed, 24 February 2016
2 389 Wed, 24 February 2016 12:43
By: Barbara Boehmer
  Why this happens with Recyclebin in Oracle
Oracle DB, 10g R2, Windows server 2008 R2
By: mdsirajoddin on Wed, 24 February 2016
7 392 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 414 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 340 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 396 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 1586 Wed, 24 February 2016 01:00
By: Michel Cadot
  Ref cursor ?
4.1.3 sql developer
By: M123 on Mon, 22 February 2016
3 300 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 556 Tue, 23 February 2016 01:58
By: pointers
  Join 2 select statements
Oracle 11203, Windows
By: kar116 on Tue, 23 February 2016
1 297 Tue, 23 February 2016 00:58
By: Michel Cadot
  Indexing advice
11g R2
By: geordibbk on Fri, 19 February 2016
6 456 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 444 Mon, 22 February 2016 12:55
By: Michel Cadot
  initialize a nested table
Oracle11gR2, windows 7
By: live4learn on Sat, 20 February 2016
3 586 Mon, 22 February 2016 00:57
By: _jum
  data view
sql+
By: vishnuy on Sun, 21 February 2016
2 271 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 441 Sat, 20 February 2016 13:27
By: Michel Cadot
  Query
11g
By: glmjoy on Fri, 19 February 2016
5 569 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 376 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 342 Fri, 19 February 2016 06:49
By: pointers
  Sql Query between String
By: sumit.cse07 on Thu, 18 February 2016
3 340 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 450 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 1409 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 447 Thu, 18 February 2016 06:09
By: sss111ind
  Minus query with string values (merged)
By: Devmunat on Tue, 16 February 2016
3 539 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 240 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 493 Wed, 17 February 2016 15:54
By: Bill B
  View tailoring
By: geordibbk on Thu, 07 January 2016
7 783 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 435 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 586 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 327 Mon, 15 February 2016 14:56
By: Bill B
  truncating a empty table
11g
By: arudesai on Tue, 09 February 2016
19 4505 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 303 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 613 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 420 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 919 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 415 Wed, 10 February 2016 15:33
By: BlackSwan
  SQL query help
Oracle 11g
By: nsankineni on Tue, 09 February 2016
3 455 Wed, 10 February 2016 02:48
By: cookiemonster
  Row lock without blocker
By: gajini on Tue, 09 February 2016
9 456 Tue, 09 February 2016 11:59
By: Bill B
  Insertion error
forms6i, oracle 10g
By: snsiddiqui on Mon, 08 February 2016
6 673 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 526 Mon, 08 February 2016 08:01
By: Bill B
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 Jun 28 19:12:10 CDT 2016

Total time taken to generate the page: 0.15895 seconds