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
oracle large query text 11gr2 on rhel (11.2.0.4.0) By: dba4oracle on Mon, 11 June 2018	9	4012	Wed, 13 June 2018 18:01 By: ramd2530
How To display last day of a century Oracle 11g By: narendraenamala on Wed, 13 June 2018	3	3124	Wed, 13 June 2018 11:23 By: Michel Cadot
USERENV, and OS_USER By: desmond30 on Wed, 13 June 2018	3	3039	Wed, 13 June 2018 11:09 By: Solomon Yakobson
How to restrict IN parameter length in Procedure Oracle 11g DB, Windows 7 By: bala.b@outlook.com on Tue, 12 June 2018	5	3364	Wed, 13 June 2018 02:04 By: bala.b@outlook.com
Want to execute 900 query's, is there any faster way to execute Oracle SQL Developer By: KavitaSSwami on Mon, 04 June 2018	9	4606	Wed, 06 June 2018 15:08 By: Bill B
Multiple tables joining By: suji6281 on Mon, 04 June 2018	5	3543	Mon, 04 June 2018 08:42 By: Michel Cadot
does execute immediate create a new connection? By: gunderj on Fri, 01 June 2018	2	2896	Fri, 01 June 2018 13:48 By: Michel Cadot
Oracle.ucp.jdbc.HarvestableConnection error Oracle 11G Suse Linux By: chrisindya on Fri, 01 June 2018	1	2873	Fri, 01 June 2018 09:35 By: John Watson
Hierarchy problem 11.2.0.3 By: Amine on Mon, 28 May 2018	3	3221	Fri, 01 June 2018 00:43 By: Barbara Boehmer
DB Port Error Oracle 11 G, Suse Linux By: chrisindya on Thu, 31 May 2018	4	3011	Thu, 31 May 2018 06:33 By: chrisindya
cannot use UTL_SMTP on Windows 10 pro from machine at home By: gunderj on Tue, 29 May 2018	7	3983	Thu, 31 May 2018 01:58 By: John Watson
error while removing ' using regex By: purnima1 on Thu, 24 May 2018	4	3113	Wed, 30 May 2018 12:33 By: Bill B
wants to generate XML oracle 9i By: AyeshaSaad on Wed, 30 May 2018	2	2577	Wed, 30 May 2018 12:26 By: Bill B
update huge table every n rows oracle 12c By: laredoeneko on Thu, 24 May 2018	10	3690	Tue, 29 May 2018 09:56 By: JPBoileau
relational() function DB12.2.0.1 By: John Watson on Mon, 28 May 2018	4	3310	Tue, 29 May 2018 08:29 By: cookiemonster
duplicate part of text message By: suji6281 on Sun, 27 May 2018	6	2998	Mon, 28 May 2018 13:45 By: suji6281
Alternative Sql Query By: nagaraju.ch on Sat, 26 May 2018	7	3184	Sun, 27 May 2018 15:10 By: John Watson
Adding up graphs By: Buchas on Fri, 18 May 2018	5	3196	Thu, 24 May 2018 14:22 By: Barbara Boehmer
Find substr after nth occurance of spce By: purnima1 on Tue, 22 May 2018	4	2790	Thu, 24 May 2018 05:38 By: Michel Cadot
Insert values from different tables in a single statement By: caiz on Wed, 23 May 2018	5	3195	Thu, 24 May 2018 04:33 By: Michel Cadot
connect by prior performance issue By: uman2631 on Fri, 18 May 2018	4	2961	Wed, 23 May 2018 09:13 By: uman2631
How to implement regex (merged 2) By: purnima1 on Mon, 21 May 2018	6	3117	Wed, 23 May 2018 08:17 By: Michel Cadot
Oracle Role creation on Schema By: ramya29p on Mon, 14 May 2018	6	3709	Wed, 23 May 2018 01:46 By: Barbara Boehmer
Help required for adding patition by range in table Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: msol25 on Mon, 21 May 2018	4	2765	Mon, 21 May 2018 02:05 By: msol25
Procedure Oracle 12C By: sravanakumari on Wed, 16 May 2018	2	2691	Wed, 16 May 2018 07:14 By: BlackSwan
How to set the earliest date By: KavitaSSwami on Mon, 14 May 2018	6	3345	Mon, 14 May 2018 15:22 By: BlackSwan
Query to find common column in more then two tables By: KavitaSSwami on Fri, 04 May 2018	13	8724	Mon, 14 May 2018 12:01 By: BlackSwan
SELECT WITH TIMESTAMP AND SYSDATE ORACLE 12 By: cruizji on Sun, 13 May 2018	3	3149	Mon, 14 May 2018 08:10 By: Bill B
Bulk collect for inserting million of records Oracle 11.2,Linux 6 By: senmng on Sun, 06 May 2018	11	5471	Fri, 11 May 2018 09:10 By: cookiemonster
Outer Join Question By: elmousa68 on Fri, 11 May 2018	3	2908	Fri, 11 May 2018 07:59 By: Michel Cadot
FORALL Bulk insert using variable Oracle 12.1.0, Sun OS 5.11 By: Renovator on Tue, 08 May 2018	5	4109	Thu, 10 May 2018 19:54 By: Barbara Boehmer
Main Stored procedure to execute multiple procedures Oracle 11.2,Linux By: senmng on Mon, 16 April 2018	16	8427	Mon, 07 May 2018 05:52 By: cookiemonster
Format a String with Decimal Point using REGEXP_REPLACE [Oracle Database 11G, UNIX Solaris] By: Betaroot on Wed, 02 May 2018	2	2600	Thu, 03 May 2018 10:01 By: Betaroot
SQL statement with averages By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018	3	3303	Thu, 03 May 2018 02:19 By: quirks
Stored procedure to load initial bulk load from one DB to another DB Oracle 11.2,Linux 6 By: senmng on Wed, 02 May 2018	1	2069	Wed, 02 May 2018 14:44 By: BlackSwan
Rollup master row 11.0.2.10 By: OraFerro on Tue, 01 May 2018	4	2880	Tue, 01 May 2018 23:39 By: OraFerro
how to use variable to store comma seperated values 11G By: satya_ora on Tue, 27 March 2018	10	4999	Mon, 30 April 2018 15:46 By: joy_division
roles granted to a role Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 By: wtolentino on Thu, 26 April 2018	9	4265	Sat, 28 April 2018 15:55 By: EdStevens
Executing the run time file at SQLPLUS Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Mon, 23 April 2018	16	10559	Thu, 26 April 2018 14:47 By: Bill B
Trap Constraint Errors in PL/SQL? 11g Release 11.2.0.3.0 By: whdyck on Thu, 26 April 2018	5	2839	Thu, 26 April 2018 10:10 By: Michel Cadot