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 running extremely slow
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional
By: buggleboy007 on Fri, 12 April 2019
14 10352 Wed, 17 April 2019 03:39
By: cookiemonster
  Carriage Return Finding
Oracle 11g,Windows
By: pstanand on Thu, 11 April 2019
15 4663 Fri, 12 April 2019 05:38
By: pstanand
  Explain plan attached
11g
By: venkat85 on Thu, 11 April 2019
3 3073 Fri, 12 April 2019 02:03
By: John Watson
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
32 10326 Fri, 12 April 2019 01:26
By: Michel Cadot
  Import XML file into XMLType Column
Database 11.2.0.2.0
By: ator on Fri, 05 April 2019
9 5298 Tue, 09 April 2019 10:20
By: Michel Cadot
  View my own queries
10g, RHEL 7
By: preet_kumar on Tue, 02 April 2019
6 2763 Mon, 08 April 2019 02:25
By: Roachcoach
  Import/Entry from txt file
SQL*Plus: Release 8.0.6.0.0 - Production
By: Salehin on Sat, 06 April 2019
6 3431 Sun, 07 April 2019 06:11
By: Michel Cadot
  How to split one column with dates into two with periods (from-to)
ORACLE DB
By: chrisk4@wp.pl on Sat, 06 April 2019
6 3856 Sat, 06 April 2019 11:03
By: chrisk4@wp.pl
  Storing only DATE I timestamp data type column
Oracle 12c
By: azeem87 on Thu, 04 April 2019
2 2788 Fri, 05 April 2019 00:03
By: Michel Cadot
  How To Retrieve string unto first pipe symbol in query
Oracle11g
By: ssyr on Fri, 29 March 2019
5 4083 Tue, 02 April 2019 14:03
By: Littlefoot
  Compare and contrast TRUNCATE and DELETE for a table
By: Meenakumari on Mon, 28 August 2017
9 12666 Tue, 02 April 2019 13:50
By: dragam
  Find next working day within the same period
PL SQL
By: EPerry123 on Tue, 02 April 2019
3 2686 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 3995 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 13469 Mon, 01 April 2019 10:04
By: saipradyumn
  how to replace date column
oracle 11gr2
By: tommm on Thu, 14 March 2019
6 5599 Wed, 27 March 2019 08:24
By: Michel Cadot
  Duplicate Insertion while executing Procedure
Oracle 12c
By: rajmat483 on Mon, 18 March 2019
5 4139 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 11280 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 7249 Fri, 22 March 2019 04:21
By: cookiemonster
icon14.gif trunc function and inner joins
By: rajmat483 on Thu, 07 March 2019
6 4420 Mon, 18 March 2019 06:32
By: Michel Cadot
  Performance of Virtual column referencing another table!
By: ramya29p on Fri, 15 March 2019
11 4832 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 16601 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 4054 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 4960 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 4659 Mon, 11 March 2019 08:21
By: BlackSwan
  Need suggestion on code refactoring
oracle 11g
By: harishankar_kar on Thu, 14 February 2019
14 5934 Sat, 09 March 2019 13:51
By: harishankar_kar
  nvl and is null
oracle 11g
By: harishankar_kar on Sat, 09 March 2019
13 4471 Sat, 09 March 2019 11:39
By: harishankar_kar
  Binary Integer Division
Oracle 11g R2
By: jagman on Wed, 06 March 2019
15 6654 Thu, 07 March 2019 15:30
By: Bill B
  checkbox charachter
oracle 11gr2
By: guddu_12 on Thu, 28 February 2019
7 5474 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 2916 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 3662 Tue, 26 February 2019 13:44
By: Michel Cadot
  INSERT and SELECT statements
Windows
By: philipsampson on Tue, 26 February 2019
1 3520 Tue, 26 February 2019 09:08
By: cookiemonster
  Scenario Dates
oracle 12
By: satishtab89 on Mon, 25 February 2019
13 5370 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 7509 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 5821 Fri, 22 February 2019 01:32
By: saipradyumn
  difference amount between 2 dates
By: suji6281 on Fri, 15 February 2019
21 5701 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 3304 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 3319 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 4870 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 2460 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 2646 Tue, 19 February 2019 11:42
By: EdStevens
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 Jul 25 05:13:12 CDT 2021