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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
0 3416 Thu, 01 November 2018 14:05
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 199138 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  existing state of package - Invalidated
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 14 December 2017
17 3812 Mon, 25 March 2019 07:49
By: saipradyumn
  TO_NUMBER specify the decimal separator within a query.
Oracle 11g
By: Diego G. on Tue, 19 March 2019
6 1039 Fri, 22 March 2019 04:21
By: cookiemonster
icon1.gif read and validate file
Oracle Data Base 11g r2
By: Bartholomew Kuma on Tue, 19 March 2019
11 766 Thu, 21 March 2019 00:36
By: Michel Cadot
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
23 4476 Tue, 19 March 2019 00:40
By: Michel Cadot
  Duplicate Insertion while executing Procedure
Oracle 12c
By: rajmat483 on Mon, 18 March 2019
4 799 Mon, 18 March 2019 06:48
By: cookiemonster
icon14.gif trunc function and inner joins
By: rajmat483 on Thu, 07 March 2019
6 1169 Mon, 18 March 2019 06:32
By: Michel Cadot
  how to replace date column
oracle 11gr2
By: tommm on Thu, 14 March 2019
3 552 Fri, 15 March 2019 19:29
By: tommm
  Performance of Virtual column referencing another table!
By: ramya29p on Fri, 15 March 2019
11 561 Fri, 15 March 2019 05:33
By: ramya29p
  ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1720 ORA-29024: Certificate valida
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production, windows server 2008
By: 9a5e on Thu, 14 March 2019
13 728 Fri, 15 March 2019 05:23
By: 9a5e
  SQL Data Extraction for CLOB
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: rahul1982 on Wed, 13 March 2019
10 930 Wed, 13 March 2019 02:42
By: rahul1982
  how can I allow this procedure to attach to email(pdf file in the directory), pdf file that is > 32
Oracle Database 12c
By: Nembezah on Tue, 19 February 2019
2 1296 Tue, 12 March 2019 07:40
By: BlackSwan
  Replacing bulk collect with loop
11.2.0.1.0
By: OraFerro on Wed, 06 March 2019
12 766 Mon, 11 March 2019 08:21
By: BlackSwan
  Need suggestion on code refactoring
oracle 11g
By: harishankar_kar on Thu, 14 February 2019
14 1865 Sat, 09 March 2019 13:51
By: harishankar_kar
  nvl and is null
oracle 11g
By: harishankar_kar on Sat, 09 March 2019
13 545 Sat, 09 March 2019 11:39
By: harishankar_kar
  Binary Integer Division
Oracle 11g R2
By: jagman on Wed, 06 March 2019
15 1374 Thu, 07 March 2019 15:30
By: Bill B
  checkbox charachter
oracle 11gr2
By: guddu_12 on Thu, 28 February 2019
7 1324 Fri, 01 March 2019 09:06
By: BlackSwan
  date validation
OS
By: suji6281 on Fri, 01 March 2019
13 1012 Fri, 01 March 2019 07:51
By: Michel Cadot
  How to denormalize multiple records into 1 row-
N/A
By: newuser01 on Thu, 28 February 2019
1 693 Thu, 28 February 2019 15:04
By: Michel Cadot
  Huge XML data in BLOB columns
Oracle 10g
By: Danny Freeman on Tue, 26 February 2019
2 1019 Tue, 26 February 2019 13:44
By: Michel Cadot
  INSERT and SELECT statements
Windows
By: philipsampson on Tue, 26 February 2019
1 754 Tue, 26 February 2019 09:08
By: cookiemonster
  Scenario Dates
oracle 12
By: satishtab89 on Mon, 25 February 2019
13 1238 Tue, 26 February 2019 05:45
By: cookiemonster
  Get Window User Name and MAC address after insert in RFQ table in oracle application Transaction (merged)
12.2.6
By: ashokb21 on Sun, 17 February 2019
19 2619 Fri, 22 February 2019 09:15
By: joy_division
  Parallel DDL statements in a same table with different partitions
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 19 February 2019
11 1597 Fri, 22 February 2019 01:32
By: saipradyumn
  difference amount between 2 dates
By: suji6281 on Fri, 15 February 2019
21 1708 Thu, 21 February 2019 12:52
By: suji6281
  Compare and contrast TRUNCATE and DELETE for a table
By: Meenakumari on Mon, 28 August 2017
8 8494 Thu, 21 February 2019 06:42
By: EdStevens
  How to Update the Col2 for below Table Structure
By: sonudev on Thu, 21 February 2019
7 649 Thu, 21 February 2019 06:41
By: EdStevens
  Connect by clause taking lot of time
Oracle 11g, Linux
By: rajivn786 on Wed, 20 February 2019
8 620 Wed, 20 February 2019 14:54
By: BlackSwan
  Retrun a limit set of rows
9i or 11g
By: torz on Sun, 17 February 2019
14 1358 Tue, 19 February 2019 15:53
By: Solomon Yakobson
  Scrambling the data for dev environment after refresh to hide/mask the sensitive data
oracle 11.2.0.4
By: vancouver_dba on Tue, 19 February 2019
1 535 Tue, 19 February 2019 13:57
By: Michel Cadot
  Using Window Function in a query Block - Count and Sum
Database - 12c
By: indianscout on Tue, 19 February 2019
2 588 Tue, 19 February 2019 11:42
By: EdStevens
  Executing dynamic sql using forall
12c
By: gauravgautam135 on Mon, 18 February 2019
5 777 Tue, 19 February 2019 03:23
By: John Watson
  Displaying rows as columns and grouping data
11g
By: vaibhav15211 on Mon, 18 February 2019
1 614 Mon, 18 February 2019 02:31
By: Michel Cadot
  XMLType Column Comparison in Select Query
Oracle11g
By: sotu100 on Thu, 14 February 2019
3 1359 Fri, 15 February 2019 01:06
By: Michel Cadot
  Add new columns and update to 600MB table online mode with zero downtime
Oracle 11gR2
By: srinivas.k2005 on Tue, 12 February 2019
5 1254 Thu, 14 February 2019 07:44
By: John Watson
  select Statement with CASE and month count
rdbms 12c
By: evoradba on Tue, 12 February 2019
6 915 Tue, 12 February 2019 17:32
By: BlackSwan
  Difference between sum(decode) and count
PL/SQL
By: klaartje on Tue, 12 February 2019
4 764 Tue, 12 February 2019 07:44
By: Bill B
  How to collate rows
PL/SQL
By: klaartje on Tue, 12 February 2019
6 776 Tue, 12 February 2019 07:19
By: Bill B
  Tree View, Connect by Prior on 100m records
Oracle 12c, RED HAT
By: sureshonly@hotmail.com on Sun, 10 February 2019
7 2725 Mon, 11 February 2019 16:05
By: sureshonly@hotmail.com
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: Mon Mar 25 23:32:26 CDT 2019