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 pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va oracle 11g By: Piranava on Mon, 10 June 2019	3	3835	Thu, 13 June 2019 07:24 By: Bill B
How to build a query that gets its values from a file Oracle SQL Developer Version 4.0.1.14 / windows 7.0 By: hartyshow@yahoo.fr on Tue, 11 June 2019	10	4658	Wed, 12 June 2019 10:23 By: cookiemonster
Backup Oracle 11.1 , linux By: Manishkumar on Sun, 09 June 2019	20	6540	Tue, 11 June 2019 12:35 By: Bill B
Aggregate operation on array 11.2.0.1.0 By: OraFerro on Thu, 30 May 2019	20	8365	Tue, 11 June 2019 03:56 By: OraFerro
PLS-00306: wrong number or types of arguments in call to 'FOPEN' (CM merged 2) Oracle 11GR2 By: maik2910 on Wed, 05 June 2019	4	3302	Thu, 06 June 2019 06:43 By: maik2910
Combining 3 queries into 1 Oracle11g By: ssyr on Wed, 05 June 2019	5	2343	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	2797	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	3251	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	3046	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	1702	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	2087	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	30043	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	3254	Fri, 24 May 2019 08:06 By: EdStevens
case if avec PL/SQL By: sawssen on Wed, 22 May 2019	1	1929	Thu, 23 May 2019 00:20 By: Michel Cadot
Help in building a Query By: spirit3d on Mon, 20 May 2019	4	2488	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	1508	Tue, 21 May 2019 06:37 By: Bill B
minus query using dblink Oracle 12 By: sivakumar121 on Sat, 18 May 2019	4	1900	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	2642	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	3095	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	3012	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	1604	Fri, 17 May 2019 14:00 By: Bill B
month as columns 12c By: m.abdulhaq on Sun, 12 May 2019	4	1877	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	1660	Wed, 15 May 2019 15:05 By: buggleboy007
Update in EXECUTE IMMEDIATE Oracle 11G By: RaShi.Raj on Mon, 11 April 2016	34	7892	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	2146	Tue, 14 May 2019 15:57 By: unna
Why does my SQL not work? By: jvanh on Tue, 14 May 2019	10	2125	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	3974	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	2058	Mon, 06 May 2019 06:01 By: Bill B
parent value of xmlquery Oracle 12C By: hakan_8 on Fri, 03 May 2019	4	1934	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	3015	Thu, 02 May 2019 09:54 By: cookiemonster
Runtime data stored in tables By: hapr1 on Wed, 01 May 2019	1	1398	Wed, 01 May 2019 18:19 By: BlackSwan
Converting returned rows into columns Oracle 11 By: ssmith001 on Tue, 23 April 2019	3	1914	Sun, 28 April 2019 06:26 By: Satheeshkumar.P
Inserting %RowType objects "faster" 11g By: andrew-mack on Tue, 23 April 2019	1	1529	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	2430	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	2097	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	1578	Mon, 22 April 2019 10:24 By: Bill B
update with subqueries possibilty By: shahzad-ul-hasan on Mon, 22 April 2019	2	1328	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	1828	Sat, 20 April 2019 09:47 By: Solomon Yakobson
json fetching using JSON_TABLE Oracle 12c By: sss111ind on Thu, 18 April 2019	6	1990	Sat, 20 April 2019 08:24 By: sss111ind
Comparing daywise data By: viveklnt on Sat, 20 April 2019	5	1922	Sat, 20 April 2019 02:17 By: Michel Cadot

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

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Thu Feb 27 12:32:38 CST 2020