OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
email validation oracle 10g windowsXP By: varosh81 on Fri, 28 March 2008	11	14589	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	2253	Thu, 05 January 2017 07:31 By: Michel Cadot
EXTERNAL TABLE CREATION ERROR By: vharish006 on Tue, 03 January 2017	7	7506	Wed, 04 January 2017 16:38 By: Barbara Boehmer
JSON_TABLE concurrent access issue Oracle 12C By: VeeS on Wed, 04 January 2017	1	4091	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	3986	Tue, 03 January 2017 12:52 By: Solomon Yakobson
Partitions oracle 12c By: bheemasql on Sun, 01 January 2017	4	2874	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	7650	Mon, 02 January 2017 23:20 By: grpatwari
selecting the columns dynamically 11.2.0.4 By: grpatwari on Mon, 02 January 2017	5	2645	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	15283	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	6905	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	3605	Thu, 29 December 2016 13:26 By: Bill B
query next value oracle 11g By: oracle_coorgi on Thu, 29 December 2016	8	2963	Thu, 29 December 2016 11:40 By: oracle_coorgi
Oracle sql id count Oracle, 11G By: Aleks21 on Thu, 29 December 2016	3	2170	Thu, 29 December 2016 09:26 By: Michel Cadot
display all numbers with like 11g By: glmjoy on Wed, 28 December 2016	4	2563	Wed, 28 December 2016 08:12 By: Michel Cadot
ROLLBACK usingTRUNCATE Oracle 11.2.0.3 By: pointers on Mon, 26 December 2016	5	2776	Tue, 27 December 2016 10:01 By: Michel Cadot
ORA-01426 "Numeric Overflow" By: challa384 on Tue, 27 December 2016	5	8926	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	3173	Sat, 24 December 2016 08:41 By: Solomon Yakobson
Order By Taking time Oracle By: mskphani on Thu, 22 December 2016	4	2669	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	8771	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	3038	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	3317	Thu, 22 December 2016 23:56 By: akash123
Convert a sys refcursor into table 11g R2 By: Sravz on Thu, 15 December 2016	18	16280	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	3237	Tue, 20 December 2016 06:51 By: John Watson
DEFAULT Value Behavior Oracle 11 By: saipradyumn on Fri, 16 December 2016	10	6062	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	5746	Fri, 16 December 2016 06:41 By: EdStevens
dynamic sql to grant privilege 11g By: raj85844 on Wed, 30 November 2016	17	7444	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	8675	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	5817	Fri, 16 December 2016 03:12 By: cookiemonster
Hierarchy Query Help Oracle 11g By: SADASIVAM on Thu, 15 December 2016	0	1785	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	6968	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	5208	Thu, 15 December 2016 01:47 By: Michel Cadot
Update Vs Delete&insertion Oracle 11 By: saipradyumn on Mon, 12 December 2016	9	3129	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	1948	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	2719	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	5364	Tue, 13 December 2016 08:09 By: Michel Cadot
Help in Listagg Query??? Oracle 11g By: arifs3738 on Tue, 13 December 2016	3	2828	Tue, 13 December 2016 03:14 By: pablolee
AND criteria in where clause By: blyzz on Wed, 07 December 2016	5	2721	Mon, 12 December 2016 07:20 By: Solomon Yakobson
Package Specification varaible Oracle 11g By: saipradyumn on Wed, 07 December 2016	14	5558	Fri, 09 December 2016 10:39 By: Michel Cadot
Long data type in oracle Oracle 11 By: saipradyumn on Tue, 06 December 2016	20	9594	Fri, 09 December 2016 09:51 By: BlackSwan
create trigger error in SQL By: equa on Fri, 09 December 2016	2	3651	Fri, 09 December 2016 03:00 By: Michel Cadot