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
Adding up graphs By: Buchas on Fri, 18 May 2018	5	5662	Thu, 24 May 2018 14:22 By: Barbara Boehmer
Find substr after nth occurance of spce By: purnima1 on Tue, 22 May 2018	4	4968	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	4990	Thu, 24 May 2018 04:33 By: Michel Cadot
connect by prior performance issue By: uman2631 on Fri, 18 May 2018	4	4869	Wed, 23 May 2018 09:13 By: uman2631
How to implement regex (merged 2) By: purnima1 on Mon, 21 May 2018	6	5337	Wed, 23 May 2018 08:17 By: Michel Cadot
Oracle Role creation on Schema By: ramya29p on Mon, 14 May 2018	6	5722	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	4547	Mon, 21 May 2018 02:05 By: msol25
Procedure Oracle 12C By: sravanakumari on Wed, 16 May 2018	2	4323	Wed, 16 May 2018 07:14 By: BlackSwan
How to set the earliest date By: KavitaSSwami on Mon, 14 May 2018	6	5304	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	10952	Mon, 14 May 2018 12:01 By: BlackSwan
SELECT WITH TIMESTAMP AND SYSDATE ORACLE 12 By: cruizji on Sun, 13 May 2018	3	4813	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	7584	Fri, 11 May 2018 09:10 By: cookiemonster
Outer Join Question By: elmousa68 on Fri, 11 May 2018	3	4316	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	8363	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	11362	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	4726	Thu, 03 May 2018 10:01 By: Betaroot
SQL statement with averages By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018	3	5528	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	3425	Wed, 02 May 2018 14:44 By: BlackSwan
Rollup master row 11.0.2.10 By: OraFerro on Tue, 01 May 2018	4	4677	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	8029	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	6268	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	14074	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	4669	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	7805	Wed, 25 April 2018 04:42 By: muthukrish104
Pagination Oracle 12 C By: satya_ora on Sun, 22 April 2018	3	4521	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	8303	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	5352	Mon, 23 April 2018 04:44 By: saipradyumn
Need Help In Dates sql Oraccle By: Djpats on Sat, 21 April 2018	3	4187	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	4233	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	8533	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	4500	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	5294	Mon, 16 April 2018 05:51 By: msol25
Need Help In Plsql Procedure Plsql By: Djpats on Sat, 14 April 2018	3	4990	Mon, 16 April 2018 03:23 By: cookiemonster
divide string into multiple parts By: suji6281 on Sat, 14 April 2018	13	9126	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	5756	Mon, 16 April 2018 00:34 By: Djpats
multiple selects after with clauses By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018	3	4615	Fri, 13 April 2018 00:10 By: Barbara Boehmer
group timestamp column hourly By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018	3	4100	Wed, 11 April 2018 13:00 By: Michel Cadot
365 days always oracle 11g, linux By: hisham99 on Sun, 08 April 2018	14	9928	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	11310	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	5984	Mon, 09 April 2018 09:42 By: BlackSwan