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
  Oracle SQL - Parameter in where condition to search two values from one
By: azocomposto on Fri, 01 April 2016
2 318 Fri, 01 April 2016 05:53
By: JNagtzaam
  Can RESULT_CACHE be used in a Package Function?
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: mokarem on Wed, 30 March 2016
4 369 Wed, 30 March 2016 05:39
By: John Watson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 1068 Sat, 26 March 2016 19:59
By: Barbara Boehmer
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 1218 Sat, 26 March 2016 11:44
By: pablolee
  Simplify SQL Interface to Oracle R Enterprise
Oracle 12c
By: vinhnh on Sat, 26 March 2016
2 547 Sat, 26 March 2016 04:11
By: vinhnh
  Multi Set operator (MULTISET UNION DISTINCT) in PL/SQL
11g
By: vikram_2050 on Fri, 25 March 2016
8 752 Fri, 25 March 2016 16:06
By: vikram_2050
  Multi Level Table Type Output
10G
By: vikram_2050 on Thu, 03 March 2016
2 593 Fri, 25 March 2016 13:56
By: vikram_2050
  Table LOCK
Oracle 12C
By: deepakdot on Fri, 25 March 2016
11 875 Fri, 25 March 2016 09:12
By: Bill B
  Using utl_file
11.0.2.10
By: OraFerro on Wed, 23 March 2016
6 741 Fri, 25 March 2016 07:02
By: Solomon Yakobson
  connection issue-how to reset ?
4.1.3 sql developer
By: M123 on Tue, 22 March 2016
11 625 Thu, 24 March 2016 06:37
By: EdStevens
  Update without cursor
Oracle 11G
By: Sam D. on Wed, 23 March 2016
7 425 Wed, 23 March 2016 16:46
By: Sam D.
  Compound Trigger
Oracle 11g, Windows NT
By: pstanand on Wed, 23 March 2016
5 538 Wed, 23 March 2016 15:16
By: Bill B
  compare performance
By: desmond30 on Wed, 23 March 2016
6 355 Wed, 23 March 2016 13:51
By: desmond30
  Date Functions - Finding the quarter of the year
By: CW2005 on Wed, 05 April 2006
10 4155 Wed, 23 March 2016 03:23
By: pablolee
  Cursor Variable : Ref Cursor Behavior
Oracle 11g, linux
By: Arunpandi on Thu, 17 March 2016
11 908 Tue, 22 March 2016 09:20
By: Bill B
  Split the Sum in 03 Portions
Oracle 11G, Windows 2003
By: mmohsinaziz on Mon, 21 March 2016
6 554 Tue, 22 March 2016 04:18
By: mmohsinaziz
  regexp_substr
Oracle 11.2.0.3
By: pointers on Tue, 22 March 2016
2 425 Tue, 22 March 2016 02:49
By: pointers
  saving the htp buffer to a file
By: Chuck on Tue, 12 October 2004
8 2306 Mon, 21 March 2016 08:20
By: Bill B
  Help with Function
Oracle
By: Nagaram on Fri, 18 March 2016
3 636 Mon, 21 March 2016 07:59
By: Bill B
  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 502 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 826 Wed, 16 March 2016 01:12
By: sasisan09
  package -error
4.1.3 sql developer
By: M123 on Thu, 10 March 2016
4 581 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 2331 Fri, 11 March 2016 08:49
By: slackermn
  cursor logic
4.1.3 sql developer
By: M123 on Tue, 08 March 2016
8 691 Thu, 10 March 2016 09:10
By: M123
  Grouping Query
Oracle 11g
By: sasisan09 on Thu, 09 April 2015
5 1167 Wed, 09 March 2016 14:04
By: Solomon Yakobson
  Understanding locking
12c
By: gorants on Sun, 06 March 2016
18 1051 Wed, 09 March 2016 11:55
By: Michel Cadot
  Outer query
Oracle11g
By: ssyr22 on Wed, 09 March 2016
8 517 Wed, 09 March 2016 10:57
By: gazzag
  dependency question
By: desmond30 on Wed, 09 March 2016
1 324 Wed, 09 March 2016 10:43
By: BlackSwan
  UTL_FILE
Oracle 10g
By: mano11022 on Wed, 09 March 2016
1 370 Wed, 09 March 2016 03:03
By: John Watson
  UTL_FILE
By: mskphani on Mon, 07 March 2016
2 446 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 535 Tue, 08 March 2016 10:29
By: mjm22
  Oracle SQL
11G Express Edition
By: mcdinesh.200@gmail.com on Fri, 04 March 2016
4 680 Tue, 08 March 2016 07:48
By: Bill B
  row to column
plsql
By: poppop on Sun, 06 March 2016
8 740 Mon, 07 March 2016 16:21
By: Bill B
  Issue with Sys_context
Oracle 11g, windows
By: Vijay55 on Mon, 07 March 2016
14 610 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 1861 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 469 Fri, 04 March 2016 08:18
By: cookiemonster
  Response in JSON format
Oracle , 12C, windowns
By: sunilreddy on Thu, 03 March 2016
3 564 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 555 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 669 Thu, 03 March 2016 06:10
By: Michel Cadot
  Too many results
By: pretoriaan1971 on Thu, 03 March 2016
1 383 Thu, 03 March 2016 04:48
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: Mon Dec 05 09:03:57 CST 2016

Total time taken to generate the page: 0.11152 seconds