OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Explain plan attached 11g By: venkat85 on Thu, 11 April 2019	3	1904	Fri, 12 April 2019 02:03 By: John Watson
running balance query 10g, win8.1 By: rzkhan on Thu, 14 April 2016	32	8535	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	3194	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	1877	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	2266	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	2598	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	1670	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	2818	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	11369	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	1737	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	2518	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	5248	Mon, 01 April 2019 10:04 By: saipradyumn
how to replace date column oracle 11gr2 By: tommm on Thu, 14 March 2019	6	3526	Wed, 27 March 2019 08:24 By: Michel Cadot
Duplicate Insertion while executing Procedure Oracle 12c By: rajmat483 on Mon, 18 March 2019	5	2894	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	7316	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	3317	Fri, 22 March 2019 04:21 By: cookiemonster
trunc function and inner joins By: rajmat483 on Thu, 07 March 2019	6	3242	Mon, 18 March 2019 06:32 By: Michel Cadot
Performance of Virtual column referencing another table! By: ramya29p on Fri, 15 March 2019	11	3463	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	7146	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	2787	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	3636	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	3461	Mon, 11 March 2019 08:21 By: BlackSwan
Need suggestion on code refactoring oracle 11g By: harishankar_kar on Thu, 14 February 2019	14	4355	Sat, 09 March 2019 13:51 By: harishankar_kar
nvl and is null oracle 11g By: harishankar_kar on Sat, 09 March 2019	13	3201	Sat, 09 March 2019 11:39 By: harishankar_kar
Binary Integer Division Oracle 11g R2 By: jagman on Wed, 06 March 2019	15	4612	Thu, 07 March 2019 15:30 By: Bill B
checkbox charachter oracle 11gr2 By: guddu_12 on Thu, 28 February 2019	7	3812	Fri, 01 March 2019 09:06 By: BlackSwan
date validation OS By: suji6281 on Fri, 01 March 2019	13	3490	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	1970	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	2549	Tue, 26 February 2019 13:44 By: Michel Cadot
INSERT and SELECT statements Windows By: philipsampson on Tue, 26 February 2019	1	2489	Tue, 26 February 2019 09:08 By: cookiemonster
Scenario Dates oracle 12 By: satishtab89 on Mon, 25 February 2019	13	4034	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	5677	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	3985	Fri, 22 February 2019 01:32 By: saipradyumn
difference amount between 2 dates By: suji6281 on Fri, 15 February 2019	21	4278	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	2329	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	2081	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	3169	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	1412	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	1522	Tue, 19 February 2019 11:42 By: EdStevens
Executing dynamic sql using forall 12c By: gauravgautam135 on Mon, 18 February 2019	5	1764	Tue, 19 February 2019 03:23 By: John Watson