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
DB-LINK to mysql Oracle Database 11g Release 11.2.0.1.0 By: iliyan_84@abv.bg on Wed, 21 December 2016	20	8348	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	2756	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	3026	Thu, 22 December 2016 23:56 By: akash123
Convert a sys refcursor into table 11g R2 By: Sravz on Thu, 15 December 2016	18	15629	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	2958	Tue, 20 December 2016 06:51 By: John Watson
DEFAULT Value Behavior Oracle 11 By: saipradyumn on Fri, 16 December 2016	10	5673	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	5295	Fri, 16 December 2016 06:41 By: EdStevens
dynamic sql to grant privilege 11g By: raj85844 on Wed, 30 November 2016	17	6919	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	7849	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	5376	Fri, 16 December 2016 03:12 By: cookiemonster
Hierarchy Query Help Oracle 11g By: SADASIVAM on Thu, 15 December 2016	0	1595	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	6589	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	4799	Thu, 15 December 2016 01:47 By: Michel Cadot
Update Vs Delete&insertion Oracle 11 By: saipradyumn on Mon, 12 December 2016	9	2749	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	1714	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	2423	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	5007	Tue, 13 December 2016 08:09 By: Michel Cadot
Help in Listagg Query??? Oracle 11g By: arifs3738 on Tue, 13 December 2016	3	2613	Tue, 13 December 2016 03:14 By: pablolee
AND criteria in where clause By: blyzz on Wed, 07 December 2016	5	2422	Mon, 12 December 2016 07:20 By: Solomon Yakobson
Package Specification varaible Oracle 11g By: saipradyumn on Wed, 07 December 2016	14	5231	Fri, 09 December 2016 10:39 By: Michel Cadot
Long data type in oracle Oracle 11 By: saipradyumn on Tue, 06 December 2016	20	8989	Fri, 09 December 2016 09:51 By: BlackSwan
create trigger error in SQL By: equa on Fri, 09 December 2016	2	3378	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	18530	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	3620	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	11970	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	37990	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	4271	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	3359	Tue, 06 December 2016 01:03 By: Michel Cadot
materialize view logs rfresh oracle 11gr2 By: guddu_12 on Fri, 02 December 2016	5	2581	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	2247	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	2710	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	4226	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	16657	Thu, 01 December 2016 12:39 By: Michel Cadot
Function MAX Oracle 11g By: tomekw on Thu, 01 December 2016	3	1962	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	2974	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	14112	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	11579	Tue, 29 November 2016 07:38 By: EdStevens
Function returns Record - How to select By: vactirio on Fri, 25 November 2016	8	3057	Sat, 26 November 2016 06:44 By: vactirio
How to generate a insert script as it is what ever we running the insert script? insert into dept(deptno,dname,loc) values (70,'PERSONNEL','DALLAS') By: narendraenamala on Thu, 24 November 2016	9	4106	Sat, 26 November 2016 04:40 By: Michel Cadot
using rownum oracle 10 g By: akash123 on Fri, 25 November 2016	14	4296	Fri, 25 November 2016 07:06 By: Bill B