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
  query to right outer join and sum up
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 1388 Tue, 19 April 2016 07:00
By: pointers
  Bulk collect data problem
Oracle 10g
By: cjcsegers on Fri, 15 April 2016
5 1787 Mon, 18 April 2016 12:52
By: Bill B
  random numbers
Oracle 11.2.0.3
By: pointers on Fri, 15 April 2016
5 1960 Sat, 16 April 2016 13:41
By: Michel Cadot
  sort problem with decimal
10g, win 8.1
By: rzkhan on Wed, 13 April 2016
6 2218 Fri, 15 April 2016 00:25
By: rzkhan
  Create a trigger to call a procedure
Oracle Database 11.2.0.3
By: Nagesh1985 on Wed, 13 April 2016
4 1993 Thu, 14 April 2016 08:29
By: Bill B
  Data count for Likert Scale
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Tue, 12 April 2016
9 2490 Wed, 13 April 2016 10:47
By: Michel Cadot
  Need help to build dynamic query
Oracle 11G
By: irish on Wed, 13 April 2016
1 1307 Wed, 13 April 2016 03:37
By: cookiemonster
  Stored Procedure: XML versus Array for multi-table insert
11.0.2.10
By: OraFerro on Thu, 07 April 2016
7 2599 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 2147 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 3174 Tue, 12 April 2016 06:13
By: gajini
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 1836 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 4454 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 2029 Wed, 06 April 2016 01:23
By: John Watson
  Dynamically add alias to column name for a view.
12c
By: lallaj on Mon, 04 April 2016
4 1884 Tue, 05 April 2016 06:57
By: EdStevens
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 1136 Tue, 05 April 2016 03:26
By: Michel Cadot
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 1481 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 1347 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 1922 Mon, 04 April 2016 11:59
By: John Watson
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 3025 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 18225 Mon, 04 April 2016 01:22
By: John Watson
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 4959 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 3984 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 1341 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 1730 Wed, 30 March 2016 05:39
By: John Watson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 2391 Sat, 26 March 2016 19:59
By: Barbara Boehmer
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 6003 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 2304 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 4963 Fri, 25 March 2016 16:06
By: vikram_2050
  Multi Level Table Type Output
10G
By: vikram_2050 on Thu, 03 March 2016
2 2780 Fri, 25 March 2016 13:56
By: vikram_2050
  Table LOCK
Oracle 12C
By: deepakdot on Fri, 25 March 2016
11 2946 Fri, 25 March 2016 09:12
By: Bill B
  Using utl_file
11.0.2.10
By: OraFerro on Wed, 23 March 2016
6 3007 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 2892 Thu, 24 March 2016 06:37
By: EdStevens
  Update without cursor
Oracle 11G
By: Sam D. on Wed, 23 March 2016
7 1656 Wed, 23 March 2016 16:46
By: Sam D.
  Compound Trigger
Oracle 11g, Windows NT
By: pstanand on Wed, 23 March 2016
5 2079 Wed, 23 March 2016 15:16
By: Bill B
  compare performance
By: desmond30 on Wed, 23 March 2016
6 1565 Wed, 23 March 2016 13:51
By: desmond30
  Date Functions - Finding the quarter of the year
By: CW2005 on Wed, 05 April 2006
10 7810 Wed, 23 March 2016 03:23
By: pablolee
  Cursor Variable : Ref Cursor Behavior
Oracle 11g, linux
By: Arunpandi on Thu, 17 March 2016
11 3332 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 2046 Tue, 22 March 2016 04:18
By: mmohsinaziz
  regexp_substr
Oracle 11.2.0.3
By: pointers on Tue, 22 March 2016
2 1358 Tue, 22 March 2016 02:49
By: pointers
  saving the htp buffer to a file
By: Chuck on Tue, 12 October 2004
8 4430 Mon, 21 March 2016 08:20
By: Bill B
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 May 18 13:24:10 CDT 2024