Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
41 178372 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 9832 Mon, 05 September 2011 02:20
By: Littlefoot
  connect by prior performance issue
By: uman2631 on Fri, 18 May 2018
3 272 Wed, 23 May 2018 02:58
By: Barbara Boehmer
  Oracle Role creation on Schema
By: ramya29p on Mon, 14 May 2018
6 508 Wed, 23 May 2018 01:46
By: Barbara Boehmer
  Find substr after nth occurance of spce
By: purnima1 on Tue, 22 May 2018
2 103 Tue, 22 May 2018 05:53
By: Michel Cadot
  How to implement regex (merged 2)
By: purnima1 on Mon, 21 May 2018
5 223 Mon, 21 May 2018 11:09
By: Michel Cadot
  Duplicating Excel "RATE" function in Oracle
Oracle 11.2
By: Primordial on Wed, 18 February 2015
5 3702 Mon, 21 May 2018 10:52
By: PHILLIPM.33
  Adding up graphs
By: Buchas on Fri, 18 May 2018
4 333 Mon, 21 May 2018 08:06
By: Solomon Yakobson
  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 157 Mon, 21 May 2018 02:05
By: msol25
  Materialised Views - FAST Refresh
Oracle 11g
By: chat2raj.s on Wed, 16 May 2018
8 706 Thu, 17 May 2018 02:18
By: chat2raj.s
  Procedure
Oracle 12C
By: sravanakumari on Wed, 16 May 2018
2 454 Wed, 16 May 2018 07:14
By: BlackSwan
  How to set the earliest date
By: KavitaSSwami on Mon, 14 May 2018
6 299 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 1721 Mon, 14 May 2018 12:01
By: BlackSwan
  SELECT WITH TIMESTAMP AND SYSDATE
ORACLE 12
By: cruizji on Sun, 13 May 2018
3 453 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 1530 Fri, 11 May 2018 09:10
By: cookiemonster
  Outer Join Question
By: elmousa68 on Fri, 11 May 2018
3 737 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 724 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 2331 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 87919 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 616 Thu, 03 May 2018 10:01
By: Betaroot
  SQL statement with averages
By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018
3 1253 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 429 Wed, 02 May 2018 14:44
By: BlackSwan
  Rollup master row
11.0.2.10
By: OraFerro on Tue, 01 May 2018
4 842 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 1907 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 1384 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 1674 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 576 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 1345 Wed, 25 April 2018 04:42
By: muthukrish104
  Pagination
Oracle 12 C
By: satya_ora on Sun, 22 April 2018
3 799 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 1782 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 1258 Mon, 23 April 2018 04:44
By: saipradyumn
  Need Help In Dates
sql Oraccle
By: Djpats on Sat, 21 April 2018
3 726 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 911 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 1454 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 717 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 682 Mon, 16 April 2018 05:51
By: msol25
  Need Help In Plsql Procedure
Plsql
By: Djpats on Sat, 14 April 2018
3 1078 Mon, 16 April 2018 03:23
By: cookiemonster
  divide string into multiple parts
By: suji6281 on Sat, 14 April 2018
13 1418 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 1062 Mon, 16 April 2018 00:34
By: Djpats
  multiple selects after with clauses
By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018
3 1049 Fri, 13 April 2018 00:10
By: Barbara Boehmer
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Wed May 23 06:17:26 CDT 2018