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
  need to modify the column datatype from varchar to number
By: saipavan.plsql on Wed, 06 April 2016
3 1608 Tue, 19 April 2016 13:23
By: Bill B
  TO_DATE formating
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 1797 Tue, 19 April 2016 08:34
By: cookiemonster
  query to right outer join and sum up
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 1421 Tue, 19 April 2016 07:00
By: pointers
  Bulk collect data problem
Oracle 10g
By: cjcsegers on Fri, 15 April 2016
5 1818 Mon, 18 April 2016 12:52
By: Bill B
  random numbers
Oracle 11.2.0.3
By: pointers on Fri, 15 April 2016
5 1999 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 2256 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 2024 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 2531 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 1332 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 2630 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 2197 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 3235 Tue, 12 April 2016 06:13
By: gajini
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 1877 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 4516 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 2059 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 1925 Tue, 05 April 2016 06:57
By: EdStevens
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 1172 Tue, 05 April 2016 03:26
By: Michel Cadot
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 1520 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 1382 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 1971 Mon, 04 April 2016 11:59
By: John Watson
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 3069 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 18306 Mon, 04 April 2016 01:22
By: John Watson
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 5011 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 4034 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 1374 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 1765 Wed, 30 March 2016 05:39
By: John Watson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 2432 Sat, 26 March 2016 19:59
By: Barbara Boehmer
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 6097 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 2350 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 5034 Fri, 25 March 2016 16:06
By: vikram_2050
  Multi Level Table Type Output
10G
By: vikram_2050 on Thu, 03 March 2016
2 2828 Fri, 25 March 2016 13:56
By: vikram_2050
  Table LOCK
Oracle 12C
By: deepakdot on Fri, 25 March 2016
11 2986 Fri, 25 March 2016 09:12
By: Bill B
  Using utl_file
11.0.2.10
By: OraFerro on Wed, 23 March 2016
6 3056 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 2920 Thu, 24 March 2016 06:37
By: EdStevens
  Update without cursor
Oracle 11G
By: Sam D. on Wed, 23 March 2016
7 1689 Wed, 23 March 2016 16:46
By: Sam D.
  Compound Trigger
Oracle 11g, Windows NT
By: pstanand on Wed, 23 March 2016
5 2108 Wed, 23 March 2016 15:16
By: Bill B
  compare performance
By: desmond30 on Wed, 23 March 2016
6 1597 Wed, 23 March 2016 13:51
By: desmond30
  Date Functions - Finding the quarter of the year
By: CW2005 on Wed, 05 April 2006
10 7865 Wed, 23 March 2016 03:23
By: pablolee
  Cursor Variable : Ref Cursor Behavior
Oracle 11g, linux
By: Arunpandi on Thu, 17 March 2016
11 3380 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 2094 Tue, 22 March 2016 04:18
By: mmohsinaziz
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: Fri Jun 28 09:36:48 CDT 2024