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
Find substr after nth occurance of spce By: purnima1 on Tue, 22 May 2018	4	3250	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	3672	Thu, 24 May 2018 04:33 By: Michel Cadot
connect by prior performance issue By: uman2631 on Fri, 18 May 2018	4	3445	Wed, 23 May 2018 09:13 By: uman2631
How to implement regex (merged 2) By: purnima1 on Mon, 21 May 2018	6	3729	Wed, 23 May 2018 08:17 By: Michel Cadot
Oracle Role creation on Schema By: ramya29p on Mon, 14 May 2018	6	4180	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	3243	Mon, 21 May 2018 02:05 By: msol25
Procedure Oracle 12C By: sravanakumari on Wed, 16 May 2018	2	3156	Wed, 16 May 2018 07:14 By: BlackSwan
How to set the earliest date By: KavitaSSwami on Mon, 14 May 2018	6	3823	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	9114	Mon, 14 May 2018 12:01 By: BlackSwan
SELECT WITH TIMESTAMP AND SYSDATE ORACLE 12 By: cruizji on Sun, 13 May 2018	3	3730	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	5945	Fri, 11 May 2018 09:10 By: cookiemonster
Outer Join Question By: elmousa68 on Fri, 11 May 2018	3	3232	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	5140	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	9116	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	3020	Thu, 03 May 2018 10:01 By: Betaroot
SQL statement with averages By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018	3	3867	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	2397	Wed, 02 May 2018 14:44 By: BlackSwan
Rollup master row 11.0.2.10 By: OraFerro on Tue, 01 May 2018	4	3306	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	5579	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	4767	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	11784	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	3327	Thu, 26 April 2018 10:10 By: Michel Cadot
Table select show blank oracle 12c Windows 2012 By: muthukrish104 on Sun, 22 April 2018	16	6540	Wed, 25 April 2018 04:42 By: muthukrish104
Pagination Oracle 12 C By: satya_ora on Sun, 22 April 2018	3	3255	Mon, 23 April 2018 06:42 By: Solomon Yakobson
Handle return empty cursor in SP output parameter 11.0.2.10 By: OraFerro on Mon, 16 April 2018	9	5689	Mon, 23 April 2018 04:54 By: OraFerro
Polish Characters are missing through the SQLPLUS Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Wed, 18 April 2018	2	4037	Mon, 23 April 2018 04:44 By: saipradyumn
Need Help In Dates sql Oraccle By: Djpats on Sat, 21 April 2018	3	3032	Sat, 21 April 2018 20:20 By: Solomon Yakobson
SQL rollup count every day By: dinavahi.saradhi@gmail.co on Thu, 19 April 2018	1	3255	Thu, 19 April 2018 10:43 By: BlackSwan
Dropping a Primary Key constraint Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional By: buggleboy007 on Mon, 16 April 2018	15	5688	Wed, 18 April 2018 10:22 By: buggleboy007
modification date for package SP 11.0.2.10 By: OraFerro on Mon, 16 April 2018	4	3201	Tue, 17 April 2018 23:55 By: OraFerro
Please help for resolving error for PIPELINED table function call Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: msol25 on Mon, 16 April 2018	2	3504	Mon, 16 April 2018 05:51 By: msol25
Need Help In Plsql Procedure Plsql By: Djpats on Sat, 14 April 2018	3	3939	Mon, 16 April 2018 03:23 By: cookiemonster
divide string into multiple parts By: suji6281 on Sat, 14 April 2018	13	7504	Mon, 16 April 2018 01:46 By: _jum
Problem in adding Html code in PL/SQL procedure By: Djpats on Sat, 14 April 2018	3	3972	Mon, 16 April 2018 00:34 By: Djpats
multiple selects after with clauses By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018	3	3330	Fri, 13 April 2018 00:10 By: Barbara Boehmer
group timestamp column hourly By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018	3	3114	Wed, 11 April 2018 13:00 By: Michel Cadot
365 days always oracle 11g, linux By: hisham99 on Sun, 08 April 2018	14	7561	Wed, 11 April 2018 09:41 By: JPBoileau
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Sat, 07 April 2018	7	5771	Wed, 11 April 2018 09:14 By: saipradyumn
Oracle 12C error tracing and debugging issue (merged 2) By: ImSandip on Mon, 09 April 2018	5	4392	Mon, 09 April 2018 09:42 By: BlackSwan
Spell out numbers to words By: Cyrille PETIT on Thu, 14 March 2002	17	17110	Fri, 06 April 2018 12:12 By: Solomon Yakobson