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
  execute immediate
11gR2, windows 7
By: deep_saha on Sat, 07 January 2017
6 453 Sun, 08 January 2017 02:37
By: Michel Cadot
  How to Move fast the data from one database to another database ?
By: sivaparam on Fri, 06 January 2017
2 605 Fri, 06 January 2017 13:22
By: Bill B
  Shrink space
Oracle 11g/12c
By: srinivas.k2005 on Fri, 06 January 2017
3 427 Fri, 06 January 2017 10:10
By: srinivas.k2005
  email validation
oracle 10g windowsXP
By: varosh81 on Fri, 28 March 2008
11 7445 Thu, 05 January 2017 08:23
By: cookiemonster
  Collections - Nested Tables and VARRAY
Oracle 11.2.0.3
By: pointers on Thu, 05 January 2017
3 361 Thu, 05 January 2017 07:31
By: Michel Cadot
  EXTERNAL TABLE CREATION ERROR
By: vharish006 on Tue, 03 January 2017
7 495 Wed, 04 January 2017 16:38
By: Barbara Boehmer
  JSON_TABLE concurrent access issue
Oracle 12C
By: VeeS on Wed, 04 January 2017
1 305 Wed, 04 January 2017 14:41
By: BlackSwan
  SYSDATE - 1 'MM' for JAN showing 0 instead of 12
Oracle
By: aceboku on Tue, 03 January 2017
8 513 Tue, 03 January 2017 12:52
By: Solomon Yakobson
  Partitions
oracle 12c
By: bheemasql on Sun, 01 January 2017
4 654 Tue, 03 January 2017 09:49
By: Bill B
  Insert the data into dynamically created table (2 threads merged by bb)
11.2.0.4
By: grpatwari on Thu, 18 August 2016
15 1066 Mon, 02 January 2017 23:20
By: grpatwari
  selecting the columns dynamically
11.2.0.4
By: grpatwari on Mon, 02 January 2017
5 462 Mon, 02 January 2017 06:16
By: Michel Cadot
  Problem accessing external tables over network
Oracle 10g Windows 2003 server Windows XP
By: Iain on Mon, 16 June 2008
14 3792 Fri, 30 December 2016 00:51
By: rizuane
  Calculate percentage based on month
Oracle 11.2.0.3.0
By: amarjadhav on Tue, 27 December 2016
9 908 Thu, 29 December 2016 13:56
By: Barbara Boehmer
  Query table names from dba_tables
Oracle Database 12c 12.1.0.2.0 - 64bit Production
By: abhi_orcl on Thu, 29 December 2016
7 473 Thu, 29 December 2016 13:26
By: Bill B
  query next value
oracle 11g
By: oracle_coorgi on Thu, 29 December 2016
8 407 Thu, 29 December 2016 11:40
By: oracle_coorgi
  Oracle sql id count
Oracle, 11G
By: Aleks21 on Thu, 29 December 2016
3 343 Thu, 29 December 2016 09:26
By: Michel Cadot
  display all numbers with like
11g
By: glmjoy on Wed, 28 December 2016
4 383 Wed, 28 December 2016 08:12
By: Michel Cadot
  ROLLBACK usingTRUNCATE
Oracle 11.2.0.3
By: pointers on Mon, 26 December 2016
5 547 Tue, 27 December 2016 10:01
By: Michel Cadot
icon5.gif ORA-01426 "Numeric Overflow"
By: challa384 on Tue, 27 December 2016
5 407 Tue, 27 December 2016 07:32
By: Bill B
  How to bypass the selective rows from SQL Analytic function
Oracle 11.2.0.1.0
By: jimit_shaili on Fri, 23 December 2016
4 612 Sat, 24 December 2016 08:41
By: Solomon Yakobson
  Order By Taking time
Oracle
By: mskphani on Thu, 22 December 2016
4 687 Fri, 23 December 2016 11:19
By: Michel Cadot
  DB-LINK to mysql
Oracle Database 11g Release 11.2.0.1.0
By: iliyan_84@abv.bg on Wed, 21 December 2016
20 870 Fri, 23 December 2016 07:25
By: iliyan_84@abv.bg
  Quantity allocation to discount slabs
Oracle 11.2.0.1.0
By: jimit_shaili on Mon, 19 December 2016
4 656 Fri, 23 December 2016 03:07
By: jimit_shaili
  transforming rows to columns
oracle 10 G and 11 G
By: akash123 on Thu, 22 December 2016
10 566 Thu, 22 December 2016 23:56
By: akash123
  Convert a sys refcursor into table
11g R2
By: Sravz on Thu, 15 December 2016
18 1611 Wed, 21 December 2016 08:40
By: Solomon Yakobson
  sorting of an alphanumeric value through oracle pl/sql
By: PR22 on Mon, 19 December 2016
6 714 Tue, 20 December 2016 06:51
By: John Watson
  DEFAULT Value Behavior
Oracle 11
By: saipradyumn on Fri, 16 December 2016
10 1327 Tue, 20 December 2016 05:33
By: saipradyumn
  how to generate an email on a database event?
Oracle Database, 10g, Windows Server-2003
By: mazam on Sun, 15 May 2011
14 1722 Fri, 16 December 2016 06:41
By: EdStevens
  dynamic sql to grant privilege
11g
By: raj85844 on Wed, 30 November 2016
17 1508 Fri, 16 December 2016 05:24
By: raj85844
  Extract directory path from a datafile name
11.2.x and 12.x, Windows
By: John Watson on Thu, 15 December 2016
13 977 Fri, 16 December 2016 04:41
By: cookiemonster
  Skipping code in a procedure?
SQL Developer 1.5.5
By: MyLastGamble on Thu, 15 December 2016
11 1011 Fri, 16 December 2016 03:12
By: cookiemonster
  Hierarchy Query Help
Oracle 11g
By: SADASIVAM on Thu, 15 December 2016
0 355 Thu, 15 December 2016 08:06
By: SADASIVAM
  ORA-01722: invalid number ORA-02063: preceding line from
By: mist598 on Thu, 15 December 2016
3 358 Thu, 15 December 2016 03:07
By: Michel Cadot
  Concatenating an array output into one single string
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Mon, 15 December 2014
12 1769 Thu, 15 December 2016 01:47
By: Michel Cadot
  Update Vs Delete&insertion
Oracle 11
By: saipradyumn on Mon, 12 December 2016
9 512 Thu, 15 December 2016 00:47
By: saipradyumn
  Bulk bind a single attribute of a collection
Oracle 11.2.0.3
By: pointers on Wed, 14 December 2016
2 254 Wed, 14 December 2016 21:11
By: Barbara Boehmer
  Comparing CAST (multiset) with Bulk Collect
11.0.2.10
By: OraFerro on Wed, 14 December 2016
4 481 Wed, 14 December 2016 06:59
By: Solomon Yakobson
  Sending a Password protected PDF using utl_smtp
By: dineshkumar18 on Mon, 12 December 2016
8 665 Tue, 13 December 2016 08:09
By: Michel Cadot
  Help in Listagg Query???
Oracle 11g
By: arifs3738 on Tue, 13 December 2016
3 334 Tue, 13 December 2016 03:14
By: pablolee
  AND criteria in where clause
By: blyzz on Wed, 07 December 2016
5 469 Mon, 12 December 2016 07:20
By: Solomon Yakobson
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 Mar 26 08:07:19 CDT 2017

Total time taken to generate the page: 0.04735 seconds