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
Why does my SQL not work? By: jvanh on Tue, 14 May 2019	10	5171	Tue, 14 May 2019 13:39 By: Solomon Yakobson
Package transfer from one to other oracle database Oracle database 12.2 on Oracle Linux 7 By: armait on Tue, 07 May 2019	30	8972	Wed, 08 May 2019 09:42 By: Michel Cadot
How to remove line breaks and put it in excel Oracle11g By: ssyr on Thu, 02 May 2019	6	5289	Mon, 06 May 2019 06:01 By: Bill B
parent value of xmlquery Oracle 12C By: hakan_8 on Fri, 03 May 2019	4	4710	Fri, 03 May 2019 10:07 By: _jum
ORA-00933: SQL command not properly ended Oracle Live SQL By: davethewelder on Wed, 01 May 2019	8	9940	Thu, 02 May 2019 09:54 By: cookiemonster
Runtime data stored in tables By: hapr1 on Wed, 01 May 2019	1	3547	Wed, 01 May 2019 18:19 By: BlackSwan
Converting returned rows into columns Oracle 11 By: ssmith001 on Tue, 23 April 2019	3	4473	Sun, 28 April 2019 06:26 By: Satheeshkumar.P
Inserting %RowType objects "faster" 11g By: andrew-mack on Tue, 23 April 2019	1	3581	Tue, 23 April 2019 14:12 By: Michel Cadot
Query taking 40 hours to execute SQL developer By: mjpatil on Mon, 22 April 2019	10	5864	Tue, 23 April 2019 04:11 By: cookiemonster
pl/sql procedure compile error PLS-00103 11.2.0.4 By: calgary2019 on Mon, 22 April 2019	2	4457	Mon, 22 April 2019 21:30 By: BlackSwan
optimizer_feature_enable Hint Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Mon, 22 April 2019	6	4193	Mon, 22 April 2019 10:24 By: Bill B
update with subqueries possibilty By: shahzad-ul-hasan on Mon, 22 April 2019	2	3282	Mon, 22 April 2019 06:08 By: Solomon Yakobson
update collection of object type using update statement Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: fachoch@gmail.com on Fri, 19 April 2019	4	4918	Sat, 20 April 2019 09:47 By: Solomon Yakobson
json fetching using JSON_TABLE Oracle 12c By: sss111ind on Thu, 18 April 2019	6	5127	Sat, 20 April 2019 08:24 By: sss111ind
Comparing daywise data By: viveklnt on Sat, 20 April 2019	5	4287	Sat, 20 April 2019 02:17 By: Michel Cadot
Problem with selecting data 9.2.0.5.0 By: chrisk4@wp.pl on Wed, 17 April 2019	5	4724	Wed, 17 April 2019 10:03 By: Michel Cadot
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	14386	Wed, 17 April 2019 03:39 By: cookiemonster
Carriage Return Finding Oracle 11g,Windows By: pstanand on Thu, 11 April 2019	15	6570	Fri, 12 April 2019 05:38 By: pstanand
Explain plan attached 11g By: venkat85 on Thu, 11 April 2019	3	4254	Fri, 12 April 2019 02:03 By: John Watson
running balance query 10g, win8.1 By: rzkhan on Thu, 14 April 2016	32	13073	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	7707	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	4855	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	5180	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	5359	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	4400	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	5803	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	14621	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	3809	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	6185	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	26779	Mon, 01 April 2019 10:04 By: saipradyumn
how to replace date column oracle 11gr2 By: tommm on Thu, 14 March 2019	6	8706	Wed, 27 March 2019 08:24 By: Michel Cadot
Duplicate Insertion while executing Procedure Oracle 12c By: rajmat483 on Mon, 18 March 2019	5	6302	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	16765	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	16737	Fri, 22 March 2019 04:21 By: cookiemonster
trunc function and inner joins By: rajmat483 on Thu, 07 March 2019	6	6588	Mon, 18 March 2019 06:32 By: Michel Cadot
Performance of Virtual column referencing another table! By: ramya29p on Fri, 15 March 2019	11	7163	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	29282	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	5504	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	7170	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	7984	Mon, 11 March 2019 08:21 By: BlackSwan