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
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	41	178582	Thu, 23 July 2015 10:23 By: Lalit Kumar B
sticky: How to use code tags and make your code easier to read By: Littlefoot on Mon, 05 September 2011	0	9865	Mon, 05 September 2011 02:20 By: Littlefoot
Alternative Sql Query By: nagaraju.ch on Sat, 26 May 2018	1	50	Sat, 26 May 2018 05:33 By: Solomon Yakobson
update huge table every n rows oracle 12c By: laredoeneko on Thu, 24 May 2018	8	217	Fri, 25 May 2018 12:58 By: laredoeneko
Adding up graphs By: Buchas on Fri, 18 May 2018	5	419	Thu, 24 May 2018 14:22 By: Barbara Boehmer
error while removing ' using regex By: purnima1 on Thu, 24 May 2018	3	133	Thu, 24 May 2018 05:56 By: Michel Cadot
Find substr after nth occurance of spce By: purnima1 on Tue, 22 May 2018	4	210	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	160	Thu, 24 May 2018 04:33 By: Michel Cadot
connect by prior performance issue By: uman2631 on Fri, 18 May 2018	4	389	Wed, 23 May 2018 09:13 By: uman2631
How to implement regex (merged 2) By: purnima1 on Mon, 21 May 2018	6	318	Wed, 23 May 2018 08:17 By: Michel Cadot
Oracle Role creation on Schema By: ramya29p on Mon, 14 May 2018	6	592	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	3738	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	183	Mon, 21 May 2018 02:05 By: msol25
Materialised Views - FAST Refresh Oracle 11g By: chat2raj.s on Wed, 16 May 2018	8	725	Thu, 17 May 2018 02:18 By: chat2raj.s
Procedure Oracle 12C By: sravanakumari on Wed, 16 May 2018	2	474	Wed, 16 May 2018 07:14 By: BlackSwan
How to set the earliest date By: KavitaSSwami on Mon, 14 May 2018	6	322	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	1854	Mon, 14 May 2018 12:01 By: BlackSwan
SELECT WITH TIMESTAMP AND SYSDATE ORACLE 12 By: cruizji on Sun, 13 May 2018	3	467	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	1577	Fri, 11 May 2018 09:10 By: cookiemonster
Outer Join Question By: elmousa68 on Fri, 11 May 2018	3	767	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	753	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	2424	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	88055	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	633	Thu, 03 May 2018 10:01 By: Betaroot
SQL statement with averages By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018	3	1263	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	440	Wed, 02 May 2018 14:44 By: BlackSwan
Rollup master row 11.0.2.10 By: OraFerro on Tue, 01 May 2018	4	856	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	1923	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	1402	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	1759	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	588	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	1390	Wed, 25 April 2018 04:42 By: muthukrish104
Pagination Oracle 12 C By: satya_ora on Sun, 22 April 2018	3	808	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	1806	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	1268	Mon, 23 April 2018 04:44 By: saipradyumn
Need Help In Dates sql Oraccle By: Djpats on Sat, 21 April 2018	3	737	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	925	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	1468	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	727	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	689	Mon, 16 April 2018 05:51 By: msol25