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
display all numbers with like 11g By: glmjoy on Wed, 28 December 2016	4	2327	Wed, 28 December 2016 08:12 By: Michel Cadot
ROLLBACK usingTRUNCATE Oracle 11.2.0.3 By: pointers on Mon, 26 December 2016	5	2509	Tue, 27 December 2016 10:01 By: Michel Cadot
ORA-01426 "Numeric Overflow" By: challa384 on Tue, 27 December 2016	5	8431	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	2926	Sat, 24 December 2016 08:41 By: Solomon Yakobson
Order By Taking time Oracle By: mskphani on Thu, 22 December 2016	4	2429	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	8379	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	2807	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	3051	Thu, 22 December 2016 23:56 By: akash123
Convert a sys refcursor into table 11g R2 By: Sravz on Thu, 15 December 2016	18	15688	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	2980	Tue, 20 December 2016 06:51 By: John Watson
DEFAULT Value Behavior Oracle 11 By: saipradyumn on Fri, 16 December 2016	10	5698	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	5318	Fri, 16 December 2016 06:41 By: EdStevens
dynamic sql to grant privilege 11g By: raj85844 on Wed, 30 November 2016	17	6945	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	7926	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	5400	Fri, 16 December 2016 03:12 By: cookiemonster
Hierarchy Query Help Oracle 11g By: SADASIVAM on Thu, 15 December 2016	0	1614	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	6611	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	4823	Thu, 15 December 2016 01:47 By: Michel Cadot
Update Vs Delete&insertion Oracle 11 By: saipradyumn on Mon, 12 December 2016	9	2772	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	1742	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	2450	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	5041	Tue, 13 December 2016 08:09 By: Michel Cadot
Help in Listagg Query??? Oracle 11g By: arifs3738 on Tue, 13 December 2016	3	2632	Tue, 13 December 2016 03:14 By: pablolee
AND criteria in where clause By: blyzz on Wed, 07 December 2016	5	2442	Mon, 12 December 2016 07:20 By: Solomon Yakobson
Package Specification varaible Oracle 11g By: saipradyumn on Wed, 07 December 2016	14	5254	Fri, 09 December 2016 10:39 By: Michel Cadot
Long data type in oracle Oracle 11 By: saipradyumn on Tue, 06 December 2016	20	9031	Fri, 09 December 2016 09:51 By: BlackSwan
create trigger error in SQL By: equa on Fri, 09 December 2016	2	3413	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	18628	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	3651	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	12013	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	38027	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	4289	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	3382	Tue, 06 December 2016 01:03 By: Michel Cadot
materialize view logs rfresh oracle 11gr2 By: guddu_12 on Fri, 02 December 2016	5	2606	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	2268	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	2735	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	4255	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	16716	Thu, 01 December 2016 12:39 By: Michel Cadot
Function MAX Oracle 11g By: tomekw on Thu, 01 December 2016	3	1982	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	3002	Tue, 29 November 2016 15:36 By: Bill B