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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
update huge table every n rows oracle 12c By: laredoeneko on Thu, 24 May 2018	10	1634	Tue, 29 May 2018 09:56 By: JPBoileau
relational() function DB12.2.0.1 By: John Watson on Mon, 28 May 2018	4	1350	Tue, 29 May 2018 08:29 By: cookiemonster
duplicate part of text message By: suji6281 on Sun, 27 May 2018	6	1367	Mon, 28 May 2018 13:45 By: suji6281
Alternative Sql Query By: nagaraju.ch on Sat, 26 May 2018	7	1404	Sun, 27 May 2018 15:10 By: John Watson
Adding up graphs By: Buchas on Fri, 18 May 2018	5	1507	Thu, 24 May 2018 14:22 By: Barbara Boehmer
Find substr after nth occurance of spce By: purnima1 on Tue, 22 May 2018	4	1123	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	1209	Thu, 24 May 2018 04:33 By: Michel Cadot
connect by prior performance issue By: uman2631 on Fri, 18 May 2018	4	1433	Wed, 23 May 2018 09:13 By: uman2631
How to implement regex (merged 2) By: purnima1 on Mon, 21 May 2018	6	1290	Wed, 23 May 2018 08:17 By: Michel Cadot
Oracle Role creation on Schema By: ramya29p on Mon, 14 May 2018	6	1656	Wed, 23 May 2018 01:46 By: Barbara Boehmer
Duplicating Excel "RATE" function in Oracle Oracle 11.2 By: Primordial on Wed, 18 February 2015	5	5638	Mon, 21 May 2018 10:52 By: PHILLIPM.33
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	1076	Mon, 21 May 2018 02:05 By: msol25
Materialised Views - FAST Refresh Oracle 11g By: chat2raj.s on Wed, 16 May 2018	8	1828	Thu, 17 May 2018 02:18 By: chat2raj.s
Procedure Oracle 12C By: sravanakumari on Wed, 16 May 2018	2	1270	Wed, 16 May 2018 07:14 By: BlackSwan
How to set the earliest date By: KavitaSSwami on Mon, 14 May 2018	6	1240	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	4804	Mon, 14 May 2018 12:01 By: BlackSwan
SELECT WITH TIMESTAMP AND SYSDATE ORACLE 12 By: cruizji on Sun, 13 May 2018	3	1234	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	2984	Fri, 11 May 2018 09:10 By: cookiemonster
Outer Join Question By: elmousa68 on Fri, 11 May 2018	3	1429	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	1657	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	4436	Mon, 07 May 2018 05:52 By: cookiemonster
Sending table data in HTML format through PL/SQL Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production By: NewLife on Fri, 11 July 2008	13	99305	Sun, 06 May 2018 09:13 By: WASIM7377
Format a String with Decimal Point using REGEXP_REPLACE [Oracle Database 11G, UNIX Solaris] By: Betaroot on Wed, 02 May 2018	2	1174	Thu, 03 May 2018 10:01 By: Betaroot
SQL statement with averages By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018	3	1776	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	874	Wed, 02 May 2018 14:44 By: BlackSwan
Rollup master row 11.0.2.10 By: OraFerro on Tue, 01 May 2018	4	1382	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	2754	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	2116	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	3544	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	1061	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	2578	Wed, 25 April 2018 04:42 By: muthukrish104
Pagination Oracle 12 C By: satya_ora on Sun, 22 April 2018	3	1287	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	2688	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	1754	Mon, 23 April 2018 04:44 By: saipradyumn
Need Help In Dates sql Oraccle By: Djpats on Sat, 21 April 2018	3	1162	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	1312	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	2252	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	1155	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	1108	Mon, 16 April 2018 05:51 By: msol25
Need Help In Plsql Procedure Plsql By: Djpats on Sat, 14 April 2018	3	1530	Mon, 16 April 2018 03:23 By: cookiemonster