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
  html character to unicode
11g
By: mshrkshl on Mon, 29 February 2016
2 340 Mon, 29 February 2016 03:43
By: mshrkshl
  Finding the source of the Company
By: hypesslearner on Sat, 27 February 2016
11 726 Mon, 29 February 2016 00:04
By: Littlefoot
  String Printing by PL/SQL code?
10g
By: thiruvari on Sat, 27 February 2016
6 544 Sat, 27 February 2016 14:35
By: Michel Cadot
  Volume Apportioned to right volumen bands
Oracle 11g
By: razasheikh on Thu, 25 February 2016
6 504 Sat, 27 February 2016 12:31
By: BlackSwan
  character string buffer too small error in function
oracle 10g,windows 8
By: amar.podaralla@gmail.com on Sat, 27 February 2016
6 407 Sat, 27 February 2016 09:39
By: BlackSwan
  Setting LIMIT value while using Bulk Collect
Oracle 11gR2
By: raj_te on Thu, 25 February 2016
6 508 Fri, 26 February 2016 03:49
By: cookiemonster
  retrieve first changed row
By: suji6281 on Mon, 15 February 2016
35 1614 Fri, 26 February 2016 01:48
By: varlamovvp
  composite data type
4.1.3 sql developer
By: M123 on Thu, 25 February 2016
7 490 Fri, 26 February 2016 01:11
By: Michel Cadot
  Query to find all records with either same value or null value
By: ranugupta3 on Thu, 25 February 2016
5 467 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 845 Thu, 25 February 2016 04:31
By: varlamovvp
  External table error
By: techgirl123 on Wed, 24 February 2016
2 372 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 376 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 406 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 327 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 392 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 1501 Wed, 24 February 2016 01:00
By: Michel Cadot
  Ref cursor ?
4.1.3 sql developer
By: M123 on Mon, 22 February 2016
3 295 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 510 Tue, 23 February 2016 01:58
By: pointers
  Join 2 select statements
Oracle 11203, Windows
By: kar116 on Tue, 23 February 2016
1 278 Tue, 23 February 2016 00:58
By: Michel Cadot
  Indexing advice
11g R2
By: geordibbk on Fri, 19 February 2016
6 432 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 432 Mon, 22 February 2016 12:55
By: Michel Cadot
  initialize a nested table
Oracle11gR2, windows 7
By: live4learn on Sat, 20 February 2016
3 575 Mon, 22 February 2016 00:57
By: _jum
  data view
sql+
By: vishnuy on Sun, 21 February 2016
2 265 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 431 Sat, 20 February 2016 13:27
By: Michel Cadot
  Query
11g
By: glmjoy on Fri, 19 February 2016
5 554 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 360 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 327 Fri, 19 February 2016 06:49
By: pointers
  Sql Query between String
By: sumit.cse07 on Thu, 18 February 2016
3 326 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 437 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 1381 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 434 Thu, 18 February 2016 06:09
By: sss111ind
  Minus query with string values (merged)
By: Devmunat on Tue, 16 February 2016
3 534 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 227 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 473 Wed, 17 February 2016 15:54
By: Bill B
  View tailoring
By: geordibbk on Thu, 07 January 2016
7 761 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 419 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 576 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 312 Mon, 15 February 2016 14:56
By: Bill B
  truncating a empty table
11g
By: arudesai on Tue, 09 February 2016
19 4466 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 288 Sun, 14 February 2016 11:08
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: Thu May 26 03:49:53 CDT 2016

Total time taken to generate the page: 0.21595 seconds