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
  Pattern Matching for Multivalue
Oracle 11g R2
By: javed.khan on Tue, 03 May 2016
11 745 Fri, 20 May 2016 09:48
By: Bill B
  ORA-30928: Connect by filtering phase runs out of temp tablespace 30928. 00000 - "Connect by filter
Oracle 11G R2
By: Kanagaraj2007 on Tue, 03 May 2016
5 1006 Wed, 04 May 2016 04:46
By: Michel Cadot
  SQL Query to fetch not matching records
12 C Windows NT
By: pstanand on Mon, 02 May 2016
5 585 Tue, 03 May 2016 02:10
By: Michel Cadot
  call a web service in a function in plsql
oracle 10g
By: shahrezaei on Sat, 30 April 2016
1 573 Sat, 30 April 2016 07:24
By: BlackSwan
  how to match multiple wildcards via metadata table
By: joy_division on Fri, 29 April 2016
5 654 Mon, 02 May 2016 16:15
By: Barbara Boehmer
  Oracle Lock
Oracle 10g
By: prashant_ora on Thu, 28 April 2016
6 461 Thu, 28 April 2016 12:28
By: Bill B
  Index on composite foreign key
Oracle 11
By: RaShi.Raj on Thu, 28 April 2016
11 888 Thu, 28 April 2016 10:06
By: Bill B
  Stale Materialised view
Oracle 10.2.0.4.0
By: brown_zzz on Thu, 28 April 2016
3 638 Thu, 28 April 2016 06:24
By: brown_zzz
  Trigger to prevent delete based on SQL statement
11.0.2.10
By: OraFerro on Thu, 28 April 2016
22 1046 Fri, 29 April 2016 13:30
By: Barbara Boehmer
  Update Query
Oracle 12C Windows NT
By: pstanand on Thu, 28 April 2016
8 695 Thu, 28 April 2016 12:29
By: Bill B
  Dynamic selection of data in query
oracle 11g
By: rocky_007 on Thu, 28 April 2016
7 586 Thu, 28 April 2016 10:24
By: Bill B
  How to suppress messages from FTP server?
11.2
By: YIMORAF on Sun, 01 May 2016
4 642 Tue, 03 May 2016 10:18
By: ThomasG
  Alphanumeric Sequence Generator
By: msyogi on Tue, 03 May 2016
7 727 Tue, 03 May 2016 05:28
By: msyogi
  HELP TO FORM DYNAMIC INSERT QUERY IN PL/SQL
By: ibnelyas on Fri, 29 April 2016
4 577 Tue, 03 May 2016 01:53
By: muhammadadnan198@gmail.co
  get row counts daily
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
By: TorontoTrader on Mon, 25 April 2016
4 375 Mon, 25 April 2016 11:43
By: TorontoTrader
  error creating external via dbms_utility.exec_ddl_statement@myDB
Oracle 11.2.9.1.0
By: gunderj on Mon, 25 April 2016
12 1038 Sat, 30 April 2016 06:58
By: gunderj
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
13 872 Mon, 11 April 2016 09:30
By: cookiemonster
  Data count for Likert Scale
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Tue, 12 April 2016
9 711 Wed, 13 April 2016 10:47
By: Michel Cadot
  Dynamic SQL - with CONCAT function
Oracle 11g
By: ORAGENASHOK on Thu, 21 April 2016
9 707 Fri, 22 April 2016 06:18
By: Solomon Yakobson
  Need help to build dynamic query
Oracle 11G
By: irish on Wed, 13 April 2016
1 523 Wed, 13 April 2016 03:37
By: cookiemonster
  sort problem with decimal
10g, win 8.1
By: rzkhan on Wed, 13 April 2016
6 780 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 679 Thu, 14 April 2016 08:29
By: Bill B
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
21 2184 Wed, 20 July 2016 07:19
By: SheliaWilson
  Bulk collect data problem
Oracle 10g
By: cjcsegers on Fri, 15 April 2016
5 694 Mon, 18 April 2016 12:52
By: Bill B
  random numbers
Oracle 11.2.0.3
By: pointers on Fri, 15 April 2016
5 874 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 924 Fri, 22 April 2016 15:14
By: Solomon Yakobson
  Dbms_schedule
Oracle Database, 10g, Windows 7
By: azamkhan on Fri, 22 April 2016
2 692 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 1278 Sun, 24 April 2016 10:39
By: John Watson
  Partitioning Tables
Oracle 11g, Unix
By: ninan on Sat, 23 April 2016
11 1062 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 809 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 683 Wed, 20 April 2016 07:11
By: pointers
  TO_DATE formating
Oracle 11.2.0.3
By: pointers on Tue, 19 April 2016
5 551 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 387 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 1846 Thu, 21 April 2016 06:00
By: posefant
  Joining four tables..need help
By: dbJuniorAdmin on Sun, 24 April 2016
12 701 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 807 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 418 Mon, 25 April 2016 07:37
By: msol25
  difference between "child rows" and "siblings rows "
11g
By: sivaparam on Sat, 09 April 2016
2 634 Sat, 09 April 2016 14:58
By: Barbara Boehmer
  Nested table with object type
ORACLE 11g
By: ORAGENASHOK on Sat, 09 April 2016
14 2174 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 852 Wed, 13 April 2016 03:12
By: OraFerro
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: Sun Oct 22 18:10:53 CDT 2017

Total time taken to generate the page: 0.01986 seconds