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
  Dynamically add alias to column name for a view.
12c
By: lallaj on Mon, 04 April 2016
4 293 Tue, 05 April 2016 06:57
By: EdStevens
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 195 Tue, 05 April 2016 03:26
By: Michel Cadot
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 238 Tue, 05 April 2016 00:30
By: Michel Cadot
  find Characters which are not present in keyboard
Oracle 10g
By: sss111ind on Mon, 04 April 2016
2 252 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 299 Mon, 04 April 2016 11:59
By: John Watson
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 391 Mon, 04 April 2016 09:09
By: Solomon Yakobson
  need help to find CityJail_8.sql script
oraqle sql
By: gregorydouglas89 on Sat, 02 April 2016
11 6075 Mon, 04 April 2016 01:22
By: John Watson
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 908 Fri, 01 April 2016 16:31
By: yashi7777
  Subtracting dates
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: javon13 on Thu, 31 March 2016
9 560 Fri, 01 April 2016 14:26
By: Barbara Boehmer
  Oracle SQL - Parameter in where condition to search two values from one
By: azocomposto on Fri, 01 April 2016
2 255 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 308 Wed, 30 March 2016 05:39
By: John Watson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 633 Sat, 26 March 2016 19:59
By: Barbara Boehmer
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 1057 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 414 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 476 Fri, 25 March 2016 16:06
By: vikram_2050
  Multi Level Table Type Output
10G
By: vikram_2050 on Thu, 03 March 2016
2 466 Fri, 25 March 2016 13:56
By: vikram_2050
  Table LOCK
Oracle 12C
By: deepakdot on Fri, 25 March 2016
11 715 Fri, 25 March 2016 09:12
By: Bill B
  Using utl_file
11.0.2.10
By: OraFerro on Wed, 23 March 2016
6 618 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 519 Thu, 24 March 2016 06:37
By: EdStevens
  Update without cursor
Oracle 11G
By: Sam D. on Wed, 23 March 2016
7 325 Wed, 23 March 2016 16:46
By: Sam D.
  Compound Trigger
Oracle 11g, Windows NT
By: pstanand on Wed, 23 March 2016
5 398 Wed, 23 March 2016 15:16
By: Bill B
  compare performance
By: desmond30 on Wed, 23 March 2016
6 270 Wed, 23 March 2016 13:51
By: desmond30
  Date Functions - Finding the quarter of the year
By: CW2005 on Wed, 05 April 2006
10 3853 Wed, 23 March 2016 03:23
By: pablolee
  Cursor Variable : Ref Cursor Behavior
Oracle 11g, linux
By: Arunpandi on Thu, 17 March 2016
11 785 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 437 Tue, 22 March 2016 04:18
By: mmohsinaziz
  regexp_substr
Oracle 11.2.0.3
By: pointers on Tue, 22 March 2016
2 317 Tue, 22 March 2016 02:49
By: pointers
  saving the htp buffer to a file
By: Chuck on Tue, 12 October 2004
8 2130 Mon, 21 March 2016 08:20
By: Bill B
  Help with Function
Oracle
By: Nagaram on Fri, 18 March 2016
3 520 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 396 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 735 Wed, 16 March 2016 01:12
By: sasisan09
  package -error
4.1.3 sql developer
By: M123 on Thu, 10 March 2016
4 453 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 2220 Fri, 11 March 2016 08:49
By: slackermn
  cursor logic
4.1.3 sql developer
By: M123 on Tue, 08 March 2016
8 544 Thu, 10 March 2016 09:10
By: M123
  Grouping Query
Oracle 11g
By: sasisan09 on Thu, 09 April 2015
5 1070 Wed, 09 March 2016 14:04
By: Solomon Yakobson
  Understanding locking
12c
By: gorants on Sun, 06 March 2016
18 897 Wed, 09 March 2016 11:55
By: Michel Cadot
  Outer query
Oracle11g
By: ssyr22 on Wed, 09 March 2016
8 420 Wed, 09 March 2016 10:57
By: gazzag
  dependency question
By: desmond30 on Wed, 09 March 2016
1 250 Wed, 09 March 2016 10:43
By: BlackSwan
  UTL_FILE
Oracle 10g
By: mano11022 on Wed, 09 March 2016
1 285 Wed, 09 March 2016 03:03
By: John Watson
  UTL_FILE
By: mskphani on Mon, 07 March 2016
2 366 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 408 Tue, 08 March 2016 10:29
By: mjm22
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: Tue May 31 10:13:46 CDT 2016

Total time taken to generate the page: 0.15074 seconds