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
json filter unusual behaviour Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 By: sss111ind on Wed, 29 May 2019	3	2730	Wed, 29 May 2019 07:48 By: cookiemonster
can we call an sql script from the code of a stored procedure By: santosh_only on Thu, 25 May 2006	28	31663	Mon, 27 May 2019 04:24 By: William Robertson
How to get all child records from a table with multiple self referential integrity constraints? (merged 3) 11g By: rrcr on Thu, 23 May 2019	8	4088	Fri, 24 May 2019 08:06 By: EdStevens
case if avec PL/SQL By: sawssen on Wed, 22 May 2019	1	2490	Thu, 23 May 2019 00:20 By: Michel Cadot
Help in building a Query By: spirit3d on Mon, 20 May 2019	4	3253	Tue, 21 May 2019 06:50 By: Bill B
Sql query taking long time to execut By: haider_1pk on Tue, 21 May 2019	2	2134	Tue, 21 May 2019 06:37 By: Bill B
minus query using dblink Oracle 12 By: sivakumar121 on Sat, 18 May 2019	4	2707	Mon, 20 May 2019 11:50 By: Bill B
Loop after fetch on generic SYS_REFCURSOR 11.2.0.1.0 By: OraFerro on Sun, 19 May 2019	9	3862	Mon, 20 May 2019 11:47 By: Bill B
Error: ORA-00980: synonym translation is no longer valid By: abs on Thu, 09 May 2019	5	4486	Mon, 20 May 2019 01:09 By: sandycullen
Disable FND_FILE.PUT_LINE(FND_FILE.LOG 12.0.1.2 By: vaibhav15211 on Thu, 16 May 2019	8	4006	Sat, 18 May 2019 00:33 By: Michel Cadot
write to the file from PL SQL oracle 11 By: ykozhevnikov on Fri, 17 May 2019	3	2150	Fri, 17 May 2019 14:00 By: Bill B
month as columns 12c By: m.abdulhaq on Sun, 12 May 2019	4	2464	Thu, 16 May 2019 01:34 By: m.abdulhaq
How to get or concatenate a value from inner most query Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional By: buggleboy007 on Tue, 14 May 2019	2	2226	Wed, 15 May 2019 15:05 By: buggleboy007
Update in EXECUTE IMMEDIATE Oracle 11G By: RaShi.Raj on Mon, 11 April 2016	34	9041	Wed, 15 May 2019 12:39 By: cookiemonster
Extract clob xml data to get node value Oracle RDBMS, 12.1, Windows By: unna on Mon, 13 May 2019	5	3251	Tue, 14 May 2019 15:57 By: unna
Why does my SQL not work? By: jvanh on Tue, 14 May 2019	10	2699	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	4786	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	2668	Mon, 06 May 2019 06:01 By: Bill B
parent value of xmlquery Oracle 12C By: hakan_8 on Fri, 03 May 2019	4	2547	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	4775	Thu, 02 May 2019 09:54 By: cookiemonster
Runtime data stored in tables By: hapr1 on Wed, 01 May 2019	1	1778	Wed, 01 May 2019 18:19 By: BlackSwan
Converting returned rows into columns Oracle 11 By: ssmith001 on Tue, 23 April 2019	3	2470	Sun, 28 April 2019 06:26 By: Satheeshkumar.P
Inserting %RowType objects "faster" 11g By: andrew-mack on Tue, 23 April 2019	1	1996	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	3133	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	2566	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	2195	Mon, 22 April 2019 10:24 By: Bill B
update with subqueries possibilty By: shahzad-ul-hasan on Mon, 22 April 2019	2	1775	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	2441	Sat, 20 April 2019 09:47 By: Solomon Yakobson
json fetching using JSON_TABLE Oracle 12c By: sss111ind on Thu, 18 April 2019	6	2562	Sat, 20 April 2019 08:24 By: sss111ind
Comparing daywise data By: viveklnt on Sat, 20 April 2019	5	2545	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	2393	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	9769	Wed, 17 April 2019 03:39 By: cookiemonster
Carriage Return Finding Oracle 11g,Windows By: pstanand on Thu, 11 April 2019	15	4184	Fri, 12 April 2019 05:38 By: pstanand
Explain plan attached 11g By: venkat85 on Thu, 11 April 2019	3	2673	Fri, 12 April 2019 02:03 By: John Watson
running balance query 10g, win8.1 By: rzkhan on Thu, 14 April 2016	32	9690	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	4680	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	2431	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	3071	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	3453	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	2373	Fri, 05 April 2019 00:03 By: Michel Cadot

Pages (1262): [ « ‹ 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Sat Jan 23 01:54:32 CST 2021