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
  Query to find common column in more then two tables
By: KavitaSSwami on Fri, 04 May 2018
13 3019 Mon, 14 May 2018 12:01
By: BlackSwan
  SELECT WITH TIMESTAMP AND SYSDATE
ORACLE 12
By: cruizji on Sun, 13 May 2018
3 703 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 2044 Fri, 11 May 2018 09:10
By: cookiemonster
  Outer Join Question
By: elmousa68 on Fri, 11 May 2018
3 1003 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 1037 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 3203 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 90022 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 789 Thu, 03 May 2018 10:01
By: Betaroot
  SQL statement with averages
By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018
3 1406 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 562 Wed, 02 May 2018 14:44
By: BlackSwan
  Rollup master row
11.0.2.10
By: OraFerro on Tue, 01 May 2018
4 1008 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 2164 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 1588 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 2408 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 670 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 1762 Wed, 25 April 2018 04:42
By: muthukrish104
  Pagination
Oracle 12 C
By: satya_ora on Sun, 22 April 2018
3 887 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 1992 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 1355 Mon, 23 April 2018 04:44
By: saipradyumn
  Need Help In Dates
sql Oraccle
By: Djpats on Sat, 21 April 2018
3 816 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 971 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 1616 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 780 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 731 Mon, 16 April 2018 05:51
By: msol25
  Need Help In Plsql Procedure
Plsql
By: Djpats on Sat, 14 April 2018
3 1154 Mon, 16 April 2018 03:23
By: cookiemonster
  divide string into multiple parts
By: suji6281 on Sat, 14 April 2018
13 1820 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 1137 Mon, 16 April 2018 00:34
By: Djpats
  multiple selects after with clauses
By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018
3 1117 Fri, 13 April 2018 00:10
By: Barbara Boehmer
  group timestamp column hourly
By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018
3 858 Wed, 11 April 2018 13:00
By: Michel Cadot
  365 days always
oracle 11g, linux
By: hisham99 on Sun, 08 April 2018
14 1923 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 1581 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 990 Mon, 09 April 2018 09:42
By: BlackSwan
  Spell out numbers to words
By: Cyrille PETIT on Thu, 14 March 2002
17 10268 Fri, 06 April 2018 12:12
By: Solomon Yakobson
  Answer the query
Oracle 11g Query
By: Lokesh A on Thu, 05 April 2018
2 800 Fri, 06 April 2018 08:04
By: joy_division
  UNUSABLE INDEX on Partition table
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 03 April 2018
3 896 Tue, 03 April 2018 08:52
By: saipradyumn
  Resource allocation problem
Oracle 12c- 12.2.0.1.0
By: suneeshvr on Mon, 02 April 2018
5 828 Mon, 02 April 2018 21:11
By: suneeshvr
  Administering queue
Oracle 11.2.0.3, AIX
By: arijit2004 on Fri, 30 March 2018
13 1589 Sat, 31 March 2018 04:53
By: arijit2004
  getting error "table table1 is mutating, trigger/function may no" on executing trigger
ORacle 11g
By: gold14388 on Thu, 29 March 2018
8 1528 Fri, 30 March 2018 10:59
By: BlackSwan
  identifier 'PACK_GEO.TRAN001' must be declared
AIX, Oracle 11.2.0.3
By: arijit2004 on Fri, 30 March 2018
2 911 Fri, 30 March 2018 06:29
By: arijit2004
  How to get this table from that Database
PL/SQL Developer, unknown, Win 10
By: Nanex on Thu, 29 March 2018
2 927 Thu, 29 March 2018 08:30
By: joy_division
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: Fri Jun 22 06:40:20 CDT 2018