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
How to write SQL Query to get desire output oracle 12c By: shawaj on Fri, 31 May 2019	3	4587	Sun, 02 June 2019 23:38 By: shawaj
varchar2 byte or char semantics db any version By: John Watson on Wed, 29 May 2019	2	3325	Wed, 29 May 2019 12:19 By: John Watson
json filter unusual behaviour Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 By: sss111ind on Wed, 29 May 2019	3	4186	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	37250	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	5314	Fri, 24 May 2019 08:06 By: EdStevens
case if avec PL/SQL By: sawssen on Wed, 22 May 2019	1	3603	Thu, 23 May 2019 00:20 By: Michel Cadot
Help in building a Query By: spirit3d on Mon, 20 May 2019	4	5423	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	3368	Tue, 21 May 2019 06:37 By: Bill B
minus query using dblink Oracle 12 By: sivakumar121 on Sat, 18 May 2019	4	4603	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	7556	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	7372	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	7818	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	3546	Fri, 17 May 2019 14:00 By: Bill B
month as columns 12c By: m.abdulhaq on Sun, 12 May 2019	4	3630	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	3452	Wed, 15 May 2019 15:05 By: buggleboy007
Update in EXECUTE IMMEDIATE Oracle 11G By: RaShi.Raj on Mon, 11 April 2016	34	13862	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	9395	Tue, 14 May 2019 15:57 By: unna
Why does my SQL not work? By: jvanh on Tue, 14 May 2019	10	4507	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	7952	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	4565	Mon, 06 May 2019 06:01 By: Bill B
parent value of xmlquery Oracle 12C By: hakan_8 on Fri, 03 May 2019	4	3926	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	8844	Thu, 02 May 2019 09:54 By: cookiemonster
Runtime data stored in tables By: hapr1 on Wed, 01 May 2019	1	3035	Wed, 01 May 2019 18:19 By: BlackSwan
Converting returned rows into columns Oracle 11 By: ssmith001 on Tue, 23 April 2019	3	3865	Sun, 28 April 2019 06:26 By: Satheeshkumar.P
Inserting %RowType objects "faster" 11g By: andrew-mack on Tue, 23 April 2019	1	3026	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	5150	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	3910	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	3414	Mon, 22 April 2019 10:24 By: Bill B
update with subqueries possibilty By: shahzad-ul-hasan on Mon, 22 April 2019	2	2791	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	4215	Sat, 20 April 2019 09:47 By: Solomon Yakobson
json fetching using JSON_TABLE Oracle 12c By: sss111ind on Thu, 18 April 2019	6	4466	Sat, 20 April 2019 08:24 By: sss111ind
Comparing daywise data By: viveklnt on Sat, 20 April 2019	5	3726	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	4056	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	12997	Wed, 17 April 2019 03:39 By: cookiemonster
Carriage Return Finding Oracle 11g,Windows By: pstanand on Thu, 11 April 2019	15	5580	Fri, 12 April 2019 05:38 By: pstanand
Explain plan attached 11g By: venkat85 on Thu, 11 April 2019	3	3640	Fri, 12 April 2019 02:03 By: John Watson
running balance query 10g, win8.1 By: rzkhan on Thu, 14 April 2016	32	11761	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	6720	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	4267	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	4559	Sun, 07 April 2019 06:11 By: Michel Cadot

Pages (1268): [ « ‹ 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Wed Mar 22 08:37:35 CDT 2023