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
Combining 3 queries into 1 Oracle11g By: ssyr on Wed, 05 June 2019	5	6110	Wed, 05 June 2019 11:15 By: Bill B
Approximate 50MB files per day to be saved in Oracle Database Oracle 11gR2 By: srinivas.k2005 on Thu, 30 May 2019	1	5734	Mon, 03 June 2019 12:31 By: Bill B
select START_TIME = TO_DATE returns 0 RDBMS 12.2..0.1 on linux By: evoradba on Wed, 29 May 2019	5	6603	Mon, 03 June 2019 11:01 By: Bill B
How to write SQL Query to get desire output oracle 12c By: shawaj on Fri, 31 May 2019	3	5892	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	4623	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	5491	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	40622	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	7002	Fri, 24 May 2019 08:06 By: EdStevens
case if avec PL/SQL By: sawssen on Wed, 22 May 2019	1	4806	Thu, 23 May 2019 00:20 By: Michel Cadot
Help in building a Query By: spirit3d on Mon, 20 May 2019	4	6851	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	4528	Tue, 21 May 2019 06:37 By: Bill B
minus query using dblink Oracle 12 By: sivakumar121 on Sat, 18 May 2019	4	6463	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	10767	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	9237	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	10166	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	4744	Fri, 17 May 2019 14:00 By: Bill B
month as columns 12c By: m.abdulhaq on Sun, 12 May 2019	4	4889	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	4574	Wed, 15 May 2019 15:05 By: buggleboy007
Update in EXECUTE IMMEDIATE Oracle 11G By: RaShi.Raj on Mon, 11 April 2016	34	17682	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	13564	Tue, 14 May 2019 15:57 By: unna
Why does my SQL not work? By: jvanh on Tue, 14 May 2019	10	6119	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	10650	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	6175	Mon, 06 May 2019 06:01 By: Bill B
parent value of xmlquery Oracle 12C By: hakan_8 on Fri, 03 May 2019	4	5487	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	11036	Thu, 02 May 2019 09:54 By: cookiemonster
Runtime data stored in tables By: hapr1 on Wed, 01 May 2019	1	4194	Wed, 01 May 2019 18:19 By: BlackSwan
Converting returned rows into columns Oracle 11 By: ssmith001 on Tue, 23 April 2019	3	5168	Sun, 28 April 2019 06:26 By: Satheeshkumar.P
Inserting %RowType objects "faster" 11g By: andrew-mack on Tue, 23 April 2019	1	4214	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	6815	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	5085	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	4947	Mon, 22 April 2019 10:24 By: Bill B
update with subqueries possibilty By: shahzad-ul-hasan on Mon, 22 April 2019	2	3894	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	5713	Sat, 20 April 2019 09:47 By: Solomon Yakobson
json fetching using JSON_TABLE Oracle 12c By: sss111ind on Thu, 18 April 2019	6	5871	Sat, 20 April 2019 08:24 By: sss111ind
Comparing daywise data By: viveklnt on Sat, 20 April 2019	5	4964	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	5485	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	15621	Wed, 17 April 2019 03:39 By: cookiemonster
Carriage Return Finding Oracle 11g,Windows By: pstanand on Thu, 11 April 2019	15	7756	Fri, 12 April 2019 05:38 By: pstanand
Explain plan attached 11g By: venkat85 on Thu, 11 April 2019	3	4914	Fri, 12 April 2019 02:03 By: John Watson
running balance query 10g, win8.1 By: rzkhan on Thu, 14 April 2016	32	14835	Fri, 12 April 2019 01:26 By: Michel Cadot

Pages (1271): [ « ‹ 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Fri Sep 27 09:10:07 CDT 2024