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
  How to send sms to no of mobile numbers using url in plsql procedure
By: ANIL747 on Sat, 30 March 2019
5 3927 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 13025 Mon, 01 April 2019 10:04
By: saipradyumn
  how to replace date column
oracle 11gr2
By: tommm on Thu, 14 March 2019
6 5485 Wed, 27 March 2019 08:24
By: Michel Cadot
  Duplicate Insertion while executing Procedure
Oracle 12c
By: rajmat483 on Mon, 18 March 2019
5 4076 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 11048 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 7033 Fri, 22 March 2019 04:21
By: cookiemonster
icon14.gif trunc function and inner joins
By: rajmat483 on Thu, 07 March 2019
6 4365 Mon, 18 March 2019 06:32
By: Michel Cadot
  Performance of Virtual column referencing another table!
By: ramya29p on Fri, 15 March 2019
11 4770 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 16150 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 4002 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 4876 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 4599 Mon, 11 March 2019 08:21
By: BlackSwan
  Need suggestion on code refactoring
oracle 11g
By: harishankar_kar on Thu, 14 February 2019
14 5810 Sat, 09 March 2019 13:51
By: harishankar_kar
  nvl and is null
oracle 11g
By: harishankar_kar on Sat, 09 March 2019
13 4405 Sat, 09 March 2019 11:39
By: harishankar_kar
  Binary Integer Division
Oracle 11g R2
By: jagman on Wed, 06 March 2019
15 6571 Thu, 07 March 2019 15:30
By: Bill B
  checkbox charachter
oracle 11gr2
By: guddu_12 on Thu, 28 February 2019
7 5392 Fri, 01 March 2019 09:06
By: BlackSwan
  How to denormalize multiple records into 1 row-
N/A
By: newuser01 on Thu, 28 February 2019
1 2868 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 3618 Tue, 26 February 2019 13:44
By: Michel Cadot
  INSERT and SELECT statements
Windows
By: philipsampson on Tue, 26 February 2019
1 3472 Tue, 26 February 2019 09:08
By: cookiemonster
  Scenario Dates
oracle 12
By: satishtab89 on Mon, 25 February 2019
13 5301 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 7392 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 5708 Fri, 22 February 2019 01:32
By: saipradyumn
  difference amount between 2 dates
By: suji6281 on Fri, 15 February 2019
21 5614 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 3234 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 3270 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 4796 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 2397 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 2596 Tue, 19 February 2019 11:42
By: EdStevens
  Executing dynamic sql using forall
12c
By: gauravgautam135 on Mon, 18 February 2019
5 2776 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 2372 Mon, 18 February 2019 02:31
By: Michel Cadot
  XMLType Column Comparison in Select Query
Oracle11g
By: sotu100 on Thu, 14 February 2019
3 3071 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 3375 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 3361 Tue, 12 February 2019 17:32
By: BlackSwan
  Difference between sum(decode) and count
PL/SQL
By: klaartje on Tue, 12 February 2019
4 3033 Tue, 12 February 2019 07:44
By: Bill B
  How to collate rows
PL/SQL
By: klaartje on Tue, 12 February 2019
6 3185 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 4931 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 3365 Sat, 09 February 2019 23:50
By: spalato76
  Issue in dynamic sql.
Oracle 18c
By: rajeshsvnr on Wed, 06 February 2019
6 3824 Sat, 09 February 2019 06:37
By: Solomon Yakobson
  Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail
Unix
By: Akmmhto on Mon, 04 February 2019
2 3338 Tue, 05 February 2019 06:06
By: Akmmhto
  Account number selection from 10 parallel session
Oracle 11gR2
By: srinivas.k2005 on Fri, 01 February 2019
9 4026 Mon, 04 February 2019 10:16
By: srinivas.k2005
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: Tue Jun 15 13:56:47 CDT 2021