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
  Group By clause in inline view
Oracle Database 10g, Toad 9.7, Windows 7
By: lancer26 on Mon, 18 April 2016
6 775 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 643 Wed, 20 April 2016 07:11
By: pointers
  TO_DATE formating
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 532 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 358 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 1813 Thu, 21 April 2016 06:00
By: posefant
  Joining four tables..need help
By: dbJuniorAdmin on Sun, 24 April 2016
12 666 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 729 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 397 Mon, 25 April 2016 07:37
By: msol25
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 601 Sat, 09 April 2016 14:58
By: Barbara Boehmer
  Nested table with object type
ORACLE 11g
By: ORAGENASHOK on Sat, 09 April 2016
14 2117 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 804 Wed, 13 April 2016 03:12
By: OraFerro
  Summation on Character Variables
Oracle 10g
By: chat2raj.s on Wed, 06 April 2016
8 821 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 569 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 644 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 437 Thu, 21 April 2016 07:31
By: Solomon Yakobson
  Date Functions
Oracle 10g
By: Danny Freeman on Tue, 05 April 2016
4 786 Wed, 20 April 2016 15:58
By: Bill B
  Member functios in Collection
Oracle 11g
By: saipradyumn on Tue, 05 April 2016
1 357 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 2182 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 576 Wed, 06 April 2016 01:23
By: John Watson
  with clause logic
By: sivaparam on Mon, 04 April 2016
33 1532 Sun, 24 April 2016 06:55
By: Bill B
  GROUP BY with 3 tables
Oracle 11g
By: myoratom on Mon, 04 April 2016
2 355 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 464 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 461 Mon, 04 April 2016 15:51
By: Barbara Boehmer
  subquery with group by issue
oracle 11
By: rlicata on Mon, 04 April 2016
15 714 Mon, 04 April 2016 09:09
By: Solomon Yakobson
  narration in one line
By: shahzad-ul-hasan on Fri, 01 April 2016
12 873 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 403 Fri, 01 April 2016 05:53
By: JNagtzaam
  plsql logic (merged 3)
By: yashi7777 on Thu, 31 March 2016
32 1404 Fri, 01 April 2016 16:31
By: yashi7777
  How to create Dependency in MV
Oracle 11G
By: irish on Mon, 04 April 2016
12 1077 Tue, 12 April 2016 06:13
By: gajini
  Random distribution of sum
Oracle 11g
By: NikoTrend1 on Mon, 04 April 2016
6 633 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 987 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 8141 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 455 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 1433 Thu, 12 May 2016 06:53
By: pointers
  Simplify SQL Interface to Oracle R Enterprise
Oracle 12c
By: vinhnh on Sat, 26 March 2016
2 704 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 1195 Fri, 25 March 2016 16:06
By: vikram_2050
  Table LOCK
Oracle 12C
By: deepakdot on Fri, 25 March 2016
11 1091 Fri, 25 March 2016 09:12
By: Bill B
  Column to Row
ORACLE PL SQL
By: reach2nm on Thu, 24 March 2016
17 1383 Sat, 26 March 2016 11:44
By: pablolee
  Update without cursor
Oracle 11G
By: Sam D. on Wed, 23 March 2016
7 550 Wed, 23 March 2016 16:46
By: Sam D.
  Using utl_file
11.0.2.10
By: OraFerro on Wed, 23 March 2016
6 962 Fri, 25 March 2016 07:02
By: Solomon Yakobson
  Grouping text
11.2.0.3
By: Amine on Sat, 26 March 2016
2 1187 Sat, 26 March 2016 19:59
By: Barbara Boehmer
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: Wed Aug 23 12:43:08 CDT 2017

Total time taken to generate the page: 0.04932 seconds