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
  Get all installments based on several plans (get unique values based on a single column)
11.2.0.10
By: OraFerro on Thu, 17 March 2016
4 454 Sat, 19 March 2016 23:17
By: OraFerro
  Inserting data into local partitioned index vs global partitioned index
Oracle 11g
By: sasisan09 on Wed, 09 March 2016
6 786 Wed, 16 March 2016 01:12
By: sasisan09
  package -error
4.1.3 sql developer
By: M123 on Thu, 10 March 2016
4 531 Fri, 11 March 2016 18:31
By: Barbara Boehmer
  compare fields ignoring spaces & dashes & leading zero's
Oracle SQL developer
By: slackermn on Fri, 04 March 2016
4 2279 Fri, 11 March 2016 08:49
By: slackermn
  cursor logic
4.1.3 sql developer
By: M123 on Tue, 08 March 2016
8 618 Thu, 10 March 2016 09:10
By: M123
  Grouping Query
Oracle 11g
By: sasisan09 on Thu, 09 April 2015
5 1131 Wed, 09 March 2016 14:04
By: Solomon Yakobson
  Understanding locking
12c
By: gorants on Sun, 06 March 2016
18 999 Wed, 09 March 2016 11:55
By: Michel Cadot
  Outer query
Oracle11g
By: ssyr22 on Wed, 09 March 2016
8 483 Wed, 09 March 2016 10:57
By: gazzag
  dependency question
By: desmond30 on Wed, 09 March 2016
1 302 Wed, 09 March 2016 10:43
By: BlackSwan
  UTL_FILE
Oracle 10g
By: mano11022 on Wed, 09 March 2016
1 348 Wed, 09 March 2016 03:03
By: John Watson
  UTL_FILE
By: mskphani on Mon, 07 March 2016
2 415 Tue, 08 March 2016 12:39
By: Bill B
  MultiSet Operations on PL/SQL Tables
Oracle 10g2, Linux
By: mjm22 on Fri, 04 March 2016
5 490 Tue, 08 March 2016 10:29
By: mjm22
  Oracle SQL
11G Express Edition
By: mcdinesh.200@gmail.com on Fri, 04 March 2016
4 627 Tue, 08 March 2016 07:48
By: Bill B
  row to column
plsql
By: poppop on Sun, 06 March 2016
8 692 Mon, 07 March 2016 16:21
By: Bill B
  Issue with Sys_context
Oracle 11g, windows
By: Vijay55 on Mon, 07 March 2016
14 557 Mon, 07 March 2016 16:10
By: Bill B
  How to use function to extract 1 or 2 digit number from a string
By: blyzz on Fri, 04 March 2016
4 1834 Mon, 07 March 2016 16:07
By: Bill B
  Compile an object by oracle command for first time
Oracle 11g, windows
By: Vijay55 on Fri, 04 March 2016
4 434 Fri, 04 March 2016 08:18
By: cookiemonster
  Response in JSON format
Oracle , 12C, windowns
By: sunilreddy on Thu, 03 March 2016
3 472 Thu, 03 March 2016 06:24
By: BlackSwan
  Print 1 .. 100 numbers using Dual table in SQL statement
Any Oracle Database version
By: 9390512774 on Fri, 19 February 2016
3 532 Thu, 03 March 2016 06:11
By: Michel Cadot
  v$session
Oracle Database 12c 12.1.0.2.0 - 64bit
By: brown_zzz on Wed, 02 March 2016
4 588 Thu, 03 March 2016 06:10
By: Michel Cadot
  Too many results
By: pretoriaan1971 on Thu, 03 March 2016
1 359 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 350 Thu, 03 March 2016 02:12
By: Michel Cadot
  ORA-02292: integrity constraint error
oracle 12c
By: gorants on Wed, 02 March 2016
2 301 Wed, 02 March 2016 21:04
By: Barbara Boehmer
  "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 961 Tue, 01 March 2016 11:15
By: Solomon Yakobson
  Select only One Case results
Oralcle SQL
By: vradhak7 on Mon, 29 February 2016
2 441 Mon, 29 February 2016 09:05
By: Michel Cadot
  Account Lock ~ OS user
12c
By: deepakdot on Tue, 23 February 2016
8 659 Mon, 29 February 2016 07:14
By: deepakdot
  Not exists with union query-Help
Oracle 11G
By: Ratika on Mon, 22 February 2016
14 934 Mon, 29 February 2016 05:37
By: Michel Cadot
  html character to unicode
11g
By: mshrkshl on Mon, 29 February 2016
2 380 Mon, 29 February 2016 03:43
By: mshrkshl
  Finding the source of the Company
By: hypesslearner on Sat, 27 February 2016
11 811 Mon, 29 February 2016 00:04
By: Littlefoot
  String Printing by PL/SQL code?
10g
By: thiruvari on Sat, 27 February 2016
6 682 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 547 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 456 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 545 Fri, 26 February 2016 03:49
By: cookiemonster
  retrieve first changed row
By: suji6281 on Mon, 15 February 2016
35 1709 Fri, 26 February 2016 01:48
By: varlamovvp
  composite data type
4.1.3 sql developer
By: M123 on Thu, 25 February 2016
7 543 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 531 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 920 Thu, 25 February 2016 04:31
By: varlamovvp
  External table error
By: techgirl123 on Wed, 24 February 2016
2 439 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 427 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 463 Wed, 24 February 2016 07:59
By: Littlefoot
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: Sun Sep 25 10:59:23 CDT 2016

Total time taken to generate the page: 0.10699 seconds