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
  Find next working day within the same period
PL SQL
By: EPerry123 on Tue, 02 April 2019
3 2175 Tue, 02 April 2019 05:24
By: John Watson
  How to send sms to no of mobile numbers using url in plsql procedure
By: ANIL747 on Sat, 30 March 2019
5 3242 Mon, 01 April 2019 14:32
By: Michel Cadot
  Error in materialized view refresh path
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 28 March 2019
16 9191 Mon, 01 April 2019 10:04
By: saipradyumn
  how to replace date column
oracle 11gr2
By: tommm on Thu, 14 March 2019
6 4372 Wed, 27 March 2019 08:24
By: Michel Cadot
  Duplicate Insertion while executing Procedure
Oracle 12c
By: rajmat483 on Mon, 18 March 2019
5 3507 Wed, 27 March 2019 07:19
By: Bill B
  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 8839 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 5118 Fri, 22 March 2019 04:21
By: cookiemonster
icon14.gif trunc function and inner joins
By: rajmat483 on Thu, 07 March 2019
6 3811 Mon, 18 March 2019 06:32
By: Michel Cadot
  Performance of Virtual column referencing another table!
By: ramya29p on Fri, 15 March 2019
11 4216 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 12415 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 3432 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 4240 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 4042 Mon, 11 March 2019 08:21
By: BlackSwan
  Need suggestion on code refactoring
oracle 11g
By: harishankar_kar on Thu, 14 February 2019
14 5110 Sat, 09 March 2019 13:51
By: harishankar_kar
  nvl and is null
oracle 11g
By: harishankar_kar on Sat, 09 March 2019
13 3788 Sat, 09 March 2019 11:39
By: harishankar_kar
  Binary Integer Division
Oracle 11g R2
By: jagman on Wed, 06 March 2019
15 5766 Thu, 07 March 2019 15:30
By: Bill B
  checkbox charachter
oracle 11gr2
By: guddu_12 on Thu, 28 February 2019
7 4549 Fri, 01 March 2019 09:06
By: BlackSwan
  date validation
OS
By: suji6281 on Fri, 01 March 2019
13 4053 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 2383 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 3103 Tue, 26 February 2019 13:44
By: Michel Cadot
  INSERT and SELECT statements
Windows
By: philipsampson on Tue, 26 February 2019
1 2996 Tue, 26 February 2019 09:08
By: cookiemonster
  Scenario Dates
oracle 12
By: satishtab89 on Mon, 25 February 2019
13 4701 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 6444 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 4801 Fri, 22 February 2019 01:32
By: saipradyumn
  difference amount between 2 dates
By: suji6281 on Fri, 15 February 2019
21 4944 Thu, 21 February 2019 12:52
By: suji6281
  How to Update the Col2 for below Table Structure
By: sonudev on Thu, 21 February 2019
7 2717 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 2629 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 4055 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 1916 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 2033 Tue, 19 February 2019 11:42
By: EdStevens
  Executing dynamic sql using forall
12c
By: gauravgautam135 on Mon, 18 February 2019
5 2221 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 1890 Mon, 18 February 2019 02:31
By: Michel Cadot
  XMLType Column Comparison in Select Query
Oracle11g
By: sotu100 on Thu, 14 February 2019
3 2599 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 2817 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 2820 Tue, 12 February 2019 17:32
By: BlackSwan
  Difference between sum(decode) and count
PL/SQL
By: klaartje on Tue, 12 February 2019
4 2455 Tue, 12 February 2019 07:44
By: Bill B
  How to collate rows
PL/SQL
By: klaartje on Tue, 12 February 2019
6 2599 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 4332 Mon, 11 February 2019 16:05
By: sureshonly@hotmail.com
  Pull out string between two words in string column
Oracle 11g
By: spalato76 on Sat, 09 February 2019
3 2818 Sat, 09 February 2019 23:50
By: spalato76
  Issue in dynamic sql.
Oracle 18c
By: rajeshsvnr on Wed, 06 February 2019
6 3289 Sat, 09 February 2019 06:37
By: Solomon Yakobson
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 Sep 21 06:35:14 CDT 2020