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
  ORA-00600: internal error code
forms 6i and database 10g win xp
By: alshadbik on Tue, 23 February 2016
7 520 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 404 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 487 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 2135 Wed, 24 February 2016 01:00
By: Michel Cadot
  Ref cursor ?
4.1.3 sql developer
By: M123 on Mon, 22 February 2016
3 424 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 1039 Tue, 23 February 2016 01:58
By: pointers
  Join 2 select statements
Oracle 11203, Windows
By: kar116 on Tue, 23 February 2016
1 408 Tue, 23 February 2016 00:58
By: Michel Cadot
  Indexing advice
11g R2
By: geordibbk on Fri, 19 February 2016
6 566 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 502 Mon, 22 February 2016 12:55
By: Michel Cadot
  initialize a nested table
Oracle11gR2, windows 7
By: live4learn on Sat, 20 February 2016
3 664 Mon, 22 February 2016 00:57
By: _jum
  data view
sql+
By: vishnuy on Sun, 21 February 2016
2 353 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 531 Sat, 20 February 2016 13:27
By: Michel Cadot
  Query
11g
By: glmjoy on Fri, 19 February 2016
5 692 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 481 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 451 Fri, 19 February 2016 06:49
By: pointers
  Sql Query between String
By: sumit.cse07 on Thu, 18 February 2016
3 429 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 563 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 1733 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 562 Thu, 18 February 2016 06:09
By: sss111ind
  Minus query with string values (merged)
By: Devmunat on Tue, 16 February 2016
3 627 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 321 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 624 Wed, 17 February 2016 15:54
By: Bill B
  View tailoring
By: geordibbk on Thu, 07 January 2016
7 915 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 532 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 705 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 380 Mon, 15 February 2016 14:56
By: Bill B
  truncating a empty table
11g
By: arudesai on Tue, 09 February 2016
19 4675 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 360 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 699 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 499 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 1139 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 542 Wed, 10 February 2016 15:33
By: BlackSwan
  SQL query help
Oracle 11g
By: nsankineni on Tue, 09 February 2016
3 561 Wed, 10 February 2016 02:48
By: cookiemonster
  Row lock without blocker
By: gajini on Tue, 09 February 2016
9 591 Tue, 09 February 2016 11:59
By: Bill B
  Insertion error
forms6i, oracle 10g
By: snsiddiqui on Mon, 08 February 2016
6 807 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 647 Mon, 08 February 2016 08:01
By: Bill B
  Data Chucking based on Timewindow
By: razasheikh on Sat, 06 February 2016
10 758 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 890 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 532 Sun, 07 February 2016 09:46
By: BlackSwan
  help with a query
Oracle sql
By: zoe2003 on Sun, 07 February 2016
1 351 Sun, 07 February 2016 08:34
By: John Watson
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 16 09:33:45 CST 2017

Total time taken to generate the page: 0.08244 seconds