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 665 Fri, 06 January 2017 13:22
By: Bill B
  Shrink space
Oracle 11g/12c
By: srinivas.k2005 on Fri, 06 January 2017
3 476 Fri, 06 January 2017 10:10
By: srinivas.k2005
  email validation
oracle 10g windowsXP
By: varosh81 on Fri, 28 March 2008
11 7618 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 389 Thu, 05 January 2017 07:31
By: Michel Cadot
  EXTERNAL TABLE CREATION ERROR
By: vharish006 on Tue, 03 January 2017
7 581 Wed, 04 January 2017 16:38
By: Barbara Boehmer
  JSON_TABLE concurrent access issue
Oracle 12C
By: VeeS on Wed, 04 January 2017
1 366 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 545 Tue, 03 January 2017 12:52
By: Solomon Yakobson
  Partitions
oracle 12c
By: bheemasql on Sun, 01 January 2017
4 694 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 1111 Mon, 02 January 2017 23:20
By: grpatwari
  selecting the columns dynamically
11.2.0.4
By: grpatwari on Mon, 02 January 2017
5 526 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 4032 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 1001 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 536 Thu, 29 December 2016 13:26
By: Bill B
  query next value
oracle 11g
By: oracle_coorgi on Thu, 29 December 2016
8 457 Thu, 29 December 2016 11:40
By: oracle_coorgi
  Oracle sql id count
Oracle, 11G
By: Aleks21 on Thu, 29 December 2016
3 377 Thu, 29 December 2016 09:26
By: Michel Cadot
  display all numbers with like
11g
By: glmjoy on Wed, 28 December 2016
4 410 Wed, 28 December 2016 08:12
By: Michel Cadot
  ROLLBACK usingTRUNCATE
Oracle 11.2.0.3
By: pointers on Mon, 26 December 2016
5 578 Tue, 27 December 2016 10:01
By: Michel Cadot
icon5.gif ORA-01426 "Numeric Overflow"
By: challa384 on Tue, 27 December 2016
5 494 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 651 Sat, 24 December 2016 08:41
By: Solomon Yakobson
  Order By Taking time
Oracle
By: mskphani on Thu, 22 December 2016
4 739 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 953 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 686 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 595 Thu, 22 December 2016 23:56
By: akash123
  Convert a sys refcursor into table
11g R2
By: Sravz on Thu, 15 December 2016
18 1674 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 768 Tue, 20 December 2016 06:51
By: John Watson
  DEFAULT Value Behavior
Oracle 11
By: saipradyumn on Fri, 16 December 2016
10 1404 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 1774 Fri, 16 December 2016 06:41
By: EdStevens
  dynamic sql to grant privilege
11g
By: raj85844 on Wed, 30 November 2016
17 1553 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 1025 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 1076 Fri, 16 December 2016 03:12
By: cookiemonster
  Hierarchy Query Help
Oracle 11g
By: SADASIVAM on Thu, 15 December 2016
0 390 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 434 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 1843 Thu, 15 December 2016 01:47
By: Michel Cadot
  Update Vs Delete&insertion
Oracle 11
By: saipradyumn on Mon, 12 December 2016
9 558 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 284 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 514 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 714 Tue, 13 December 2016 08:09
By: Michel Cadot
  Help in Listagg Query???
Oracle 11g
By: arifs3738 on Tue, 13 December 2016
3 368 Tue, 13 December 2016 03:14
By: pablolee
  AND criteria in where clause
By: blyzz on Wed, 07 December 2016
5 503 Mon, 12 December 2016 07:20
By: Solomon Yakobson
  Package Specification varaible
Oracle 11g
By: saipradyumn on Wed, 07 December 2016
14 909 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: Mon May 29 04:47:25 CDT 2017

Total time taken to generate the page: 0.11714 seconds