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
  package -error
4.1.3 sql developer
By: M123 on Thu, 10 March 2016
4 745 Fri, 11 March 2016 18:31
By: Barbara Boehmer
  Issue with Sys_context
Oracle 11g, windows
By: Vijay55 on Mon, 07 March 2016
14 875 Mon, 07 March 2016 16:10
By: Bill B
  Understanding locking
12c
By: gorants on Sun, 06 March 2016
18 1399 Wed, 09 March 2016 11:55
By: Michel Cadot
  row to column
plsql
By: poppop on Sun, 06 March 2016
8 898 Mon, 07 March 2016 16:21
By: Bill B
  compare fields ignoring spaces & dashes & leading zero's
Oracle SQL developer
By: slackermn on Fri, 04 March 2016
4 2499 Fri, 11 March 2016 08:49
By: slackermn
  How to use function to extract 1 or 2 digit number from a string
By: blyzz on Fri, 04 March 2016
4 1981 Mon, 07 March 2016 16:07
By: Bill B
  Oracle SQL
11G Express Edition
By: mcdinesh.200@gmail.com on Fri, 04 March 2016
4 826 Tue, 08 March 2016 07:48
By: Bill B
  Compile an object by oracle command for first time
Oracle 11g, windows
By: Vijay55 on Fri, 04 March 2016
4 624 Fri, 04 March 2016 08:18
By: cookiemonster
  Multi Level Table Type Output
10G
By: vikram_2050 on Thu, 03 March 2016
2 775 Fri, 25 March 2016 13:56
By: vikram_2050
  Response in JSON format
Oracle , 12C, windowns
By: sunilreddy on Thu, 03 March 2016
3 975 Thu, 03 March 2016 06:24
By: BlackSwan
  Too many results
By: pretoriaan1971 on Thu, 03 March 2016
1 465 Thu, 03 March 2016 04:48
By: Michel Cadot
  end-of-file on communication channel
11.2.0.1.0
By: pointers on Thu, 03 March 2016
1 530 Thu, 03 March 2016 02:12
By: Michel Cadot
  ORA-02292: integrity constraint error
oracle 12c
By: gorants on Wed, 02 March 2016
2 450 Wed, 02 March 2016 21:04
By: Barbara Boehmer
  v$session
Oracle Database 12c 12.1.0.2.0 - 64bit
By: brown_zzz on Wed, 02 March 2016
4 1009 Thu, 03 March 2016 06:10
By: Michel Cadot
  MultiSet Operations on PL/SQL Tables
Oracle 10g2, Linux
By: mjm22 on Fri, 04 March 2016
5 702 Tue, 08 March 2016 10:29
By: mjm22
  Select only One Case results
Oralcle SQL
By: vradhak7 on Mon, 29 February 2016
2 637 Mon, 29 February 2016 09:05
By: Michel Cadot
  html character to unicode
11g
By: mshrkshl on Mon, 29 February 2016
2 498 Mon, 29 February 2016 03:43
By: mshrkshl
  Finding the source of the Company
By: hypesslearner on Sat, 27 February 2016
11 1024 Mon, 29 February 2016 00:04
By: Littlefoot
  String Printing by PL/SQL code?
10g
By: P1Oracle on Sat, 27 February 2016
6 905 Sat, 27 February 2016 14:35
By: Michel Cadot
  Hierarchical Query (merged)
Oracle 10g
By: lokimisc on Wed, 27 April 2016
7 2320 Thu, 28 April 2016 07:51
By: Michel Cadot
  composite data type
4.1.3 sql developer
By: M123 on Thu, 25 February 2016
7 727 Fri, 26 February 2016 01:11
By: Michel Cadot
  Volume Apportioned to right volumen bands
Oracle 11g
By: razasheikh on Thu, 25 February 2016
6 743 Sat, 27 February 2016 12:31
By: BlackSwan
  Setting LIMIT value while using Bulk Collect
Oracle 11gR2
By: raj_te on Thu, 25 February 2016
6 741 Fri, 26 February 2016 03:49
By: cookiemonster
  Query to find all records with either same value or null value
By: ranugupta3 on Thu, 25 February 2016
5 766 Thu, 25 February 2016 08:36
By: varlamovvp
  "ORA-01722: invalid number" errors after upgrade 12c
Oracle Database 12c (12.1.0.2.0)
By: brown_zzz on Wed, 24 February 2016
10 1487 Tue, 01 March 2016 11:15
By: Solomon Yakobson
  Why this happens with Recyclebin in Oracle
Oracle DB, 10g R2, Windows server 2008 R2
By: mdsirajoddin on Wed, 24 February 2016
7 619 Wed, 24 February 2016 11:20
By: Michel Cadot
icon5.gif General question about temporary tables
Oracle 11GR2, WIN Server 2008
By: OlafCologne on Wed, 24 February 2016
2 482 Wed, 24 February 2016 06:43
By: Michel Cadot
  character string buffer too small error in function
oracle 10g,windows 8
By: amar.podaralla@gmail.com on Sat, 27 February 2016
6 757 Sat, 27 February 2016 09:39
By: BlackSwan
  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 689 Wed, 24 February 2016 02:52
By: sss111ind
  ORA-00600: internal error code
forms 6i and database 10g win xp
By: alshadbik on Tue, 23 February 2016
7 649 Wed, 24 February 2016 07:59
By: Littlefoot
  Account Lock ~ OS user
12c
By: deepakdot on Tue, 23 February 2016
8 959 Mon, 29 February 2016 07:14
By: deepakdot
  Join 2 select statements
Oracle 11203, Windows
By: kar116 on Tue, 23 February 2016
1 539 Tue, 23 February 2016 00:58
By: Michel Cadot
  Ref cursor ?
4.1.3 sql developer
By: M123 on Mon, 22 February 2016
3 530 Tue, 23 February 2016 17:57
By: M123
  data view
sql+
By: vishnuy on Sun, 21 February 2016
2 431 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 655 Sat, 20 February 2016 13:27
By: Michel Cadot
  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 611 Mon, 22 February 2016 12:55
By: Michel Cadot
  initialize a nested table
Oracle11gR2, windows 7
By: live4learn on Sat, 20 February 2016
3 836 Mon, 22 February 2016 00:57
By: _jum
  query needed without using only where clause
10g
By: god_bunu on Fri, 04 November 2016
3 376 Sat, 05 November 2016 02:00
By: Michel Cadot
  Indexing advice
11g R2
By: geordibbk on Fri, 19 February 2016
6 697 Mon, 22 February 2016 13:10
By: Bill B
  Oracle Dates query
ORACLE, 12.1.0.2.0, WINDOWS 10
By: anil_mk on Fri, 19 February 2016
12 593 Fri, 19 February 2016 11:54
By: Michel Cadot
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: Sat Oct 21 12:49:18 CDT 2017

Total time taken to generate the page: 0.08368 seconds