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
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	2908	Sat, 24 December 2016 08:41 By: Solomon Yakobson
Order By Taking time Oracle By: mskphani on Thu, 22 December 2016	4	2418	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	8355	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	2766	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	3032	Thu, 22 December 2016 23:56 By: akash123
Convert a sys refcursor into table 11g R2 By: Sravz on Thu, 15 December 2016	18	15644	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	2963	Tue, 20 December 2016 06:51 By: John Watson
DEFAULT Value Behavior Oracle 11 By: saipradyumn on Fri, 16 December 2016	10	5677	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	5300	Fri, 16 December 2016 06:41 By: EdStevens
dynamic sql to grant privilege 11g By: raj85844 on Wed, 30 November 2016	17	6922	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	7863	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	5380	Fri, 16 December 2016 03:12 By: cookiemonster
Hierarchy Query Help Oracle 11g By: SADASIVAM on Thu, 15 December 2016	0	1599	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	6597	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	4803	Thu, 15 December 2016 01:47 By: Michel Cadot
Update Vs Delete&insertion Oracle 11 By: saipradyumn on Mon, 12 December 2016	9	2753	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	1720	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	2432	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	5019	Tue, 13 December 2016 08:09 By: Michel Cadot
Help in Listagg Query??? Oracle 11g By: arifs3738 on Tue, 13 December 2016	3	2617	Tue, 13 December 2016 03:14 By: pablolee
AND criteria in where clause By: blyzz on Wed, 07 December 2016	5	2427	Mon, 12 December 2016 07:20 By: Solomon Yakobson
Package Specification varaible Oracle 11g By: saipradyumn on Wed, 07 December 2016	14	5235	Fri, 09 December 2016 10:39 By: Michel Cadot
Long data type in oracle Oracle 11 By: saipradyumn on Tue, 06 December 2016	20	8994	Fri, 09 December 2016 09:51 By: BlackSwan
create trigger error in SQL By: equa on Fri, 09 December 2016	2	3390	Fri, 09 December 2016 03:00 By: Michel Cadot
ORA-30006 Resource Busy, acquired with Wait timeout expired Oracle 10g, Forms 6i By: chat2raj.s on Thu, 08 December 2016	13	18557	Thu, 08 December 2016 06:35 By: chat2raj.s
Trigger on Materialized View Log tables ORACLE 11G Version 11.2.0.3.0 By: arunrajv@yahoo.com on Wed, 07 December 2016	7	3626	Wed, 07 December 2016 23:02 By: arunrajv@yahoo.com
Outer Joins and To_Char Oracle 9 By: nigelcg on Tue, 01 April 2008	2	11977	Wed, 07 December 2016 15:05 By: las911
External tables (.csv) Oracle 10g, Windows Server 2003 ( 1 2) By: Rodrignra on Tue, 26 April 2011	53	37998	Wed, 07 December 2016 12:14 By: rizuane
Correct order of data in Hierarchical Query Oracle 12c By: ramjss on Sat, 19 November 2016	13	4274	Tue, 06 December 2016 04:29 By: ramjss
SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result By: pcouas on Mon, 05 December 2016	7	3365	Tue, 06 December 2016 01:03 By: Michel Cadot
materialize view logs rfresh oracle 11gr2 By: guddu_12 on Fri, 02 December 2016	5	2588	Mon, 05 December 2016 08:29 By: Bill B
Query For N number to top Sales in Region oracle 10 g By: annu-agi on Sun, 04 December 2016	6	2252	Mon, 05 December 2016 01:18 By: Michel Cadot
Element exists in a collection Oracle 11.2.0.3 By: pointers on Fri, 02 December 2016	3	2714	Fri, 02 December 2016 06:43 By: Solomon Yakobson
How to check if time is attached with date? 10.2.0 By: bluetooth420 on Wed, 30 November 2016	11	4231	Fri, 02 December 2016 03:14 By: cookiemonster
ora-06504 PL/SQL: Return types of Result Set variables or query do not match By: v4goel on Thu, 25 October 2007	11	16665	Thu, 01 December 2016 12:39 By: Michel Cadot
Function MAX Oracle 11g By: tomekw on Thu, 01 December 2016	3	1966	Thu, 01 December 2016 10:08 By: Michel Cadot
how to search for two characters in any sequence, with or without alphanumeric characters in between Oracle 11g, 12c By: namitanamburi on Tue, 29 November 2016	13	2978	Tue, 29 November 2016 15:36 By: Bill B
Star printing in PL/SQL Program Problem 11g By: ashishpatel1992 on Sat, 16 March 2013	13	14117	Tue, 29 November 2016 14:06 By: Michel Cadot
How to pass date parameters in dynamic sql? PL sql By: nukala on Mon, 28 November 2016	8	11594	Tue, 29 November 2016 07:38 By: EdStevens
Function returns Record - How to select By: vactirio on Fri, 25 November 2016	8	3062	Sat, 26 November 2016 06:44 By: vactirio