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
  How to Move fast the data from one database to another database ?
By: sivaparam on Fri, 06 January 2017
2 603 Fri, 06 January 2017 13:22
By: Bill B
  Shrink space
Oracle 11g/12c
By: srinivas.k2005 on Fri, 06 January 2017
3 425 Fri, 06 January 2017 10:10
By: srinivas.k2005
  email validation
oracle 10g windowsXP
By: varosh81 on Fri, 28 March 2008
11 7444 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 359 Thu, 05 January 2017 07:31
By: Michel Cadot
  EXTERNAL TABLE CREATION ERROR
By: vharish006 on Tue, 03 January 2017
7 490 Wed, 04 January 2017 16:38
By: Barbara Boehmer
  JSON_TABLE concurrent access issue
Oracle 12C
By: VeeS on Wed, 04 January 2017
1 303 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 512 Tue, 03 January 2017 12:52
By: Solomon Yakobson
  Partitions
oracle 12c
By: bheemasql on Sun, 01 January 2017
4 652 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 1065 Mon, 02 January 2017 23:20
By: grpatwari
  selecting the columns dynamically
11.2.0.4
By: grpatwari on Mon, 02 January 2017
5 459 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 3788 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 907 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 471 Thu, 29 December 2016 13:26
By: Bill B
  query next value
oracle 11g
By: oracle_coorgi on Thu, 29 December 2016
8 406 Thu, 29 December 2016 11:40
By: oracle_coorgi
  Oracle sql id count
Oracle, 11G
By: Aleks21 on Thu, 29 December 2016
3 341 Thu, 29 December 2016 09:26
By: Michel Cadot
  display all numbers with like
11g
By: glmjoy on Wed, 28 December 2016
4 382 Wed, 28 December 2016 08:12
By: Michel Cadot
  ROLLBACK usingTRUNCATE
Oracle 11.2.0.3
By: pointers on Mon, 26 December 2016
5 544 Tue, 27 December 2016 10:01
By: Michel Cadot
icon5.gif ORA-01426 "Numeric Overflow"
By: challa384 on Tue, 27 December 2016
5 404 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 686 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 654 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 1609 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 713 Tue, 20 December 2016 06:51
By: John Watson
  DEFAULT Value Behavior
Oracle 11
By: saipradyumn on Fri, 16 December 2016
10 1324 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 1506 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 976 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 355 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 511 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 333 Tue, 13 December 2016 03:14
By: pablolee
  AND criteria in where clause
By: blyzz on Wed, 07 December 2016
5 467 Mon, 12 December 2016 07:20
By: Solomon Yakobson
  Package Specification varaible
Oracle 11g
By: saipradyumn on Wed, 07 December 2016
14 861 Fri, 09 December 2016 10:39
By: Michel Cadot
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: Fri Mar 24 13:07:11 CDT 2017

Total time taken to generate the page: 0.06045 seconds