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
  Stored Procedure: XML versus Array for multi-table insert
11.0.2.10
By: OraFerro on Thu, 07 April 2016
7 445 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 549 Wed, 13 April 2016 00:21
By: chat2raj.s
  How to create Dependency in MV
Oracle 11G
By: irish on Mon, 04 April 2016
12 644 Tue, 12 April 2016 06:13
By: gajini
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
13 315 Mon, 11 April 2016 09:30
By: cookiemonster
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 305 Sat, 09 April 2016 14:58
By: Barbara Boehmer
  XMLAGG issue
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Wed, 06 April 2016
3 275 Wed, 06 April 2016 19:25
By: Solomon Yakobson
  Query Rewriting - Assistance Needed
Oracle 11.2.0.4, Solaris 10 1/13
By: suddhasatwa_oracle on Tue, 05 April 2016
7 353 Wed, 06 April 2016 01:23
By: John Watson
  Dynamic File Creation using UTL_FILE
Oracle 11G
By: harshadsp on Tue, 05 April 2016
6 295 Tue, 05 April 2016 08:22
By: cookiemonster
  Dynamically add alias to column name for a view.
12c
By: lallaj on Mon, 04 April 2016
4 267 Tue, 05 April 2016 06:57
By: EdStevens
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 177 Tue, 05 April 2016 03:26
By: Michel Cadot
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 218 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 231 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 279 Mon, 04 April 2016 11:59
By: John Watson
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 365 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 5999 Mon, 04 April 2016 01:22
By: John Watson
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 873 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 532 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 240 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 279 Wed, 30 March 2016 05:39
By: John Watson
  create dummy rows
Oracle 11.2.0.3
By: pointers on Mon, 28 March 2016
5 485 Mon, 28 March 2016 09:57
By: Solomon Yakobson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 542 Sat, 26 March 2016 19:59
By: Barbara Boehmer
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 983 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 393 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 425 Fri, 25 March 2016 16:06
By: vikram_2050
  Multi Level Table Type Output
10G
By: vikram_2050 on Thu, 03 March 2016
2 440 Fri, 25 March 2016 13:56
By: vikram_2050
  Table LOCK
Oracle 12C
By: deepakdot on Fri, 25 March 2016
11 654 Fri, 25 March 2016 09:12
By: Bill B
  Using utl_file
11.0.2.10
By: OraFerro on Wed, 23 March 2016
6 597 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 497 Thu, 24 March 2016 06:37
By: EdStevens
  Update without cursor
Oracle 11G
By: Sam D. on Wed, 23 March 2016
7 294 Wed, 23 March 2016 16:46
By: Sam D.
  Compound Trigger
Oracle 11g, Windows NT
By: pstanand on Wed, 23 March 2016
5 361 Wed, 23 March 2016 15:16
By: Bill B
  compare performance
By: desmond30 on Wed, 23 March 2016
6 253 Wed, 23 March 2016 13:51
By: desmond30
  Date Functions - Finding the quarter of the year
By: CW2005 on Wed, 05 April 2006
10 3779 Wed, 23 March 2016 03:23
By: pablolee
  Cursor Variable : Ref Cursor Behavior
Oracle 11g, linux
By: Arunpandi on Thu, 17 March 2016
11 757 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 422 Tue, 22 March 2016 04:18
By: mmohsinaziz
  regexp_substr
Oracle 11.2.0.3
By: pointers on Tue, 22 March 2016
2 282 Tue, 22 March 2016 02:49
By: pointers
  search for text in views
By: desmond30 on Mon, 21 March 2016
2 259 Mon, 21 March 2016 17:32
By: Barbara Boehmer
  saving the htp buffer to a file
By: Chuck on Tue, 12 October 2004
8 2108 Mon, 21 March 2016 08:20
By: Bill B
  Help with Function
Oracle
By: Nagaram on Fri, 18 March 2016
3 506 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 364 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 721 Wed, 16 March 2016 01:12
By: sasisan09
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 May 01 13:08:48 CDT 2016

Total time taken to generate the page: 0.08814 seconds