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
  Nested cursor expressions
DB 12.1.0.2
By: John Watson on Fri, 22 April 2016
25 2998 Sun, 24 April 2016 10:39
By: John Watson
  with clause logic
By: sivaparam on Mon, 04 April 2016
33 4685 Sun, 24 April 2016 06:55
By: Bill B
  need to get row count for database with 20 k tables
oracle 11 g
By: TorontoTrader on Thu, 21 April 2016
12 3057 Fri, 22 April 2016 15:14
By: Solomon Yakobson
  Dynamic SQL - with CONCAT function
Oracle 11g
By: ORAGENASHOK on Thu, 21 April 2016
9 1546 Fri, 22 April 2016 06:18
By: Solomon Yakobson
  Dbms_schedule
Oracle Database, 10g, Windows 7
By: azamkhan on Fri, 22 April 2016
2 1530 Fri, 22 April 2016 03:08
By: cookiemonster
  Nested table with object type
ORACLE 11g
By: ORAGENASHOK on Sat, 09 April 2016
14 7498 Thu, 21 April 2016 13:23
By: Barbara Boehmer
icon5.gif Error when create policy after create view. What is the problem?
PLSQL
By: quytrieu on Tue, 05 April 2016
3 1046 Thu, 21 April 2016 07:31
By: Solomon Yakobson
  Counting overlapping ID's in intersection tables.
Oracle, 12.1.0.1, AIX 7.1
By: posefant on Wed, 20 April 2016
25 3171 Thu, 21 April 2016 06:00
By: posefant
  Date Functions
Oracle 10g
By: Danny Freeman on Tue, 05 April 2016
4 1359 Wed, 20 April 2016 15:58
By: Bill B
  Group By clause in inline view
Oracle Database 10g, Toad 9.7, Windows 7
By: lancer26 on Mon, 18 April 2016
6 1484 Wed, 20 April 2016 13:44
By: live4learn
  Ids of unique error type
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
7 1408 Wed, 20 April 2016 07:11
By: pointers
  need to modify the column datatype from varchar to number
By: saipavan.plsql on Wed, 06 April 2016
3 1183 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 1311 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 1005 Tue, 19 April 2016 07:00
By: pointers
  Bulk collect data problem
Oracle 10g
By: cjcsegers on Fri, 15 April 2016
5 1369 Mon, 18 April 2016 12:52
By: Bill B
  random numbers
Oracle 11.2.0.3
By: pointers on Fri, 15 April 2016
5 1477 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 1480 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 1524 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 1803 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 913 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 1937 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 1508 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 2554 Tue, 12 April 2016 06:13
By: gajini
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 1205 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 3202 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 1578 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 1225 Tue, 05 April 2016 06:57
By: EdStevens
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 709 Tue, 05 April 2016 03:26
By: Michel Cadot
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 1105 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 874 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 1390 Mon, 04 April 2016 11:59
By: John Watson
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 2452 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 15261 Mon, 04 April 2016 01:22
By: John Watson
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 3601 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 3014 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 934 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 1180 Wed, 30 March 2016 05:39
By: John Watson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 1752 Sat, 26 March 2016 19:59
By: Barbara Boehmer
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 4226 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 1751 Sat, 26 March 2016 04:11
By: vinhnh
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 Oct 25 22:11:56 CDT 2021