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
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
21 2205 Wed, 20 July 2016 07:19
By: SheliaWilson
  Bulk collect data problem
Oracle 10g
By: cjcsegers on Fri, 15 April 2016
5 698 Mon, 18 April 2016 12:52
By: Bill B
  random numbers
Oracle 11.2.0.3
By: pointers on Fri, 15 April 2016
5 939 Sat, 16 April 2016 13:41
By: Michel Cadot
  need to get row count for database with 20 k tables
oracle 11 g
By: TorontoTrader on Thu, 21 April 2016
12 937 Fri, 22 April 2016 15:14
By: Solomon Yakobson
  Dbms_schedule
Oracle Database, 10g, Windows 7
By: azamkhan on Fri, 22 April 2016
2 708 Fri, 22 April 2016 03:08
By: cookiemonster
  Nested cursor expressions
DB 12.1.0.2
By: John Watson on Fri, 22 April 2016
25 1289 Sun, 24 April 2016 10:39
By: John Watson
  Partitioning Tables
Oracle 11g, Unix
By: ninan on Sat, 23 April 2016
11 1078 Wed, 27 April 2016 13:56
By: jyeager
  Group By clause in inline view
Oracle Database 10g, Toad 9.7, Windows 7
By: lancer26 on Mon, 18 April 2016
6 819 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 779 Wed, 20 April 2016 07:11
By: pointers
  TO_DATE formating
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 554 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 425 Tue, 19 April 2016 07:00
By: pointers
  Counting overlapping ID's in intersection tables.
Oracle, 12.1.0.1, AIX 7.1
By: posefant on Wed, 20 April 2016
25 1868 Thu, 21 April 2016 06:00
By: posefant
  Joining four tables..need help
By: dbJuniorAdmin on Sun, 24 April 2016
12 711 Tue, 26 April 2016 12:11
By: Bill B
  Unable to get values from associative arrays into a different procedure
Database:11.2.0.1.0; O/S: Linux 3.0.101-0.47.71-default x86_64
By: buggleboy007 on Mon, 25 April 2016
11 974 Mon, 02 May 2016 20:08
By: buggleboy007
  Please help for regexp_replace in oracle 11g
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: msol25 on Mon, 25 April 2016
3 451 Mon, 25 April 2016 07:37
By: msol25
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 646 Sat, 09 April 2016 14:58
By: Barbara Boehmer
  Nested table with object type
ORACLE 11g
By: ORAGENASHOK on Sat, 09 April 2016
14 2205 Thu, 21 April 2016 13:23
By: Barbara Boehmer
  Stored Procedure: XML versus Array for multi-table insert
11.0.2.10
By: OraFerro on Thu, 07 April 2016
7 878 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 872 Wed, 13 April 2016 00:21
By: chat2raj.s
  XMLAGG issue
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Xandot on Wed, 06 April 2016
3 611 Wed, 06 April 2016 19:25
By: Solomon Yakobson
  need to modify the column datatype from varchar to number
By: saipavan.plsql on Wed, 06 April 2016
3 690 Tue, 19 April 2016 13:23
By: Bill B
icon5.gif Error when create policy after create view. What is the problem?
PLSQL
By: quytrieu on Tue, 05 April 2016
3 459 Thu, 21 April 2016 07:31
By: Solomon Yakobson
  Date Functions
Oracle 10g
By: Danny Freeman on Tue, 05 April 2016
4 832 Wed, 20 April 2016 15:58
By: Bill B
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 376 Tue, 05 April 2016 03:26
By: Michel Cadot
  Dynamic File Creation using UTL_FILE
Oracle 11G ( 1 2)
By: harshadsp on Tue, 05 April 2016
76 2309 Mon, 09 May 2016 09:21
By: harshadsp
  Query Rewriting - Assistance Needed
Oracle 11.2.0.4, Solaris 10 1/13
By: suddhasatwa_oracle on Tue, 05 April 2016
7 732 Wed, 06 April 2016 01:23
By: John Watson
  with clause logic
By: sivaparam on Mon, 04 April 2016
33 1590 Sun, 24 April 2016 06:55
By: Bill B
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 377 Tue, 05 April 2016 00:30
By: Michel Cadot
  Dynamically add alias to column name for a view.
12c
By: lallaj on Mon, 04 April 2016
4 476 Tue, 05 April 2016 06:57
By: EdStevens
  find Characters which are not present in keyboard
Oracle 10g
By: sss111ind on Mon, 04 April 2016
2 489 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 754 Mon, 04 April 2016 09:09
By: Solomon Yakobson
  narration in one line
By: shahzad-ul-hasan on Fri, 01 April 2016
12 894 Tue, 26 April 2016 01:50
By: per0per0
  Oracle SQL - Parameter in where condition to search two values from one
By: azocomposto on Fri, 01 April 2016
2 443 Fri, 01 April 2016 05:53
By: JNagtzaam
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 1464 Fri, 01 April 2016 16:31
By: yashi7777
  How to create Dependency in MV
Oracle 11G
By: irish on Mon, 04 April 2016
12 1134 Tue, 12 April 2016 06:13
By: gajini
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 676 Mon, 04 April 2016 11:59
By: John Watson
  Subtracting dates
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: javon13 on Thu, 31 March 2016
9 1060 Fri, 01 April 2016 14:26
By: Barbara Boehmer
  need help to find CityJail_8.sql script
oraqle sql
By: gregorydouglas89 on Sat, 02 April 2016
11 9049 Mon, 04 April 2016 01:22
By: John Watson
  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 474 Wed, 30 March 2016 05:39
By: John Watson
  create dummy rows
Oracle 11.2.0.3
By: pointers on Mon, 28 March 2016
8 1471 Thu, 12 May 2016 06:53
By: pointers
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 Nov 18 09:47:12 CST 2017

Total time taken to generate the page: 0.08565 seconds