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
  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 880 Mon, 21 May 2018 02:05
By: msol25
  Materialised Views - FAST Refresh
Oracle 11g
By: chat2raj.s on Wed, 16 May 2018
8 1508 Thu, 17 May 2018 02:18
By: chat2raj.s
  Procedure
Oracle 12C
By: sravanakumari on Wed, 16 May 2018
2 1063 Wed, 16 May 2018 07:14
By: BlackSwan
  How to set the earliest date
By: KavitaSSwami on Mon, 14 May 2018
6 951 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 4057 Mon, 14 May 2018 12:01
By: BlackSwan
  SELECT WITH TIMESTAMP AND SYSDATE
ORACLE 12
By: cruizji on Sun, 13 May 2018
3 1009 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 2532 Fri, 11 May 2018 09:10
By: cookiemonster
  Outer Join Question
By: elmousa68 on Fri, 11 May 2018
3 1215 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 1330 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 3756 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 94034 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 993 Thu, 03 May 2018 10:01
By: Betaroot
  SQL statement with averages
By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018
3 1550 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 692 Wed, 02 May 2018 14:44
By: BlackSwan
  Rollup master row
11.0.2.10
By: OraFerro on Tue, 01 May 2018
4 1150 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 2413 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 1824 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 2871 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 854 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 2063 Wed, 25 April 2018 04:42
By: muthukrish104
  Pagination
Oracle 12 C
By: satya_ora on Sun, 22 April 2018
3 1050 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 2312 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 1520 Mon, 23 April 2018 04:44
By: saipradyumn
  Need Help In Dates
sql Oraccle
By: Djpats on Sat, 21 April 2018
3 974 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 1122 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 1851 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 955 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 890 Mon, 16 April 2018 05:51
By: msol25
  Need Help In Plsql Procedure
Plsql
By: Djpats on Sat, 14 April 2018
3 1307 Mon, 16 April 2018 03:23
By: cookiemonster
  divide string into multiple parts
By: suji6281 on Sat, 14 April 2018
13 2170 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 1329 Mon, 16 April 2018 00:34
By: Djpats
  multiple selects after with clauses
By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018
3 1287 Fri, 13 April 2018 00:10
By: Barbara Boehmer
  group timestamp column hourly
By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018
3 1017 Wed, 11 April 2018 13:00
By: Michel Cadot
  365 days always
oracle 11g, linux
By: hisham99 on Sun, 08 April 2018
14 2302 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 1770 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 1186 Mon, 09 April 2018 09:42
By: BlackSwan
  Spell out numbers to words
By: Cyrille PETIT on Thu, 14 March 2002
17 10748 Fri, 06 April 2018 12:12
By: Solomon Yakobson
  Answer the query
Oracle 11g Query
By: Lokesh A on Thu, 05 April 2018
2 961 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 1059 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 1003 Mon, 02 April 2018 21:11
By: suneeshvr
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: Sun Aug 19 12:11:08 CDT 2018