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
	Announcement: How to use [code] tags and make your code easier to read By: Michel Cadot on Thu, 01 November 2018	0	5159	Thu, 01 November 2018 14:05 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	204651	Tue, 06 November 2018 14:17 By: Solomon Yakobson
How to create cumulative data has been moved to Forms by the moderator.
	Incorrect work of the sql query with JOIN. Oracle, 11g, Win 7 By: orajav on Thu, 13 June 2019	18	1944	Fri, 14 June 2019 05:50 By: orajav
SQL to get the Percentage in the Seeded Report of Purchase Requisition has been moved to Business Intelligence by the moderator.
	Using the Sql query to find employees who were recruited on the same day or on neighboring days. Oracle, 11g, Win 7 By: orajav on Wed, 12 June 2019	21	2371	Thu, 13 June 2019 12:46 By: orajav
	MV Refresh On Commit Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Thu, 06 June 2019	1	1546	Thu, 13 June 2019 07:37 By: Bill B
	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	2130	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	1480	Wed, 12 June 2019 10:23 By: cookiemonster
	Backup Oracle 11.1 , linux By: Manishkumar on Sun, 09 June 2019	20	3813	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	4449	Tue, 11 June 2019 03:56 By: OraFerro
	Returning into clause for insert selectstatements Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Fri, 07 June 2019	5	2756	Mon, 10 June 2019 03:34 By: Michel Cadot
	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	737	Thu, 06 June 2019 06:43 By: maik2910
	Combining 3 queries into 1 Oracle11g By: ssyr on Wed, 05 June 2019	5	608	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	1564	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	933	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	939	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	417	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	368	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	25461	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	854	Fri, 24 May 2019 08:06 By: EdStevens
	case if avec PL/SQL By: sawssen on Wed, 22 May 2019	1	416	Thu, 23 May 2019 00:20 By: Michel Cadot
	Help in building a Query By: spirit3d on Mon, 20 May 2019	4	577	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	402	Tue, 21 May 2019 06:37 By: Bill B
	minus query using dblink Oracle 12 By: sivakumar121 on Sat, 18 May 2019	4	530	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	644	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	1068	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	773	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	359	Fri, 17 May 2019 14:00 By: Bill B
	month as columns 12c By: m.abdulhaq on Sun, 12 May 2019	4	645	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	534	Wed, 15 May 2019 15:05 By: buggleboy007
	Update in EXECUTE IMMEDIATE Oracle 11G By: RaShi.Raj on Mon, 11 April 2016	34	3736	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	502	Tue, 14 May 2019 15:57 By: unna
	Why does my SQL not work? By: jvanh on Tue, 14 May 2019	10	473	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	1214	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	771	Mon, 06 May 2019 06:01 By: Bill B
	parent value of xmlquery Oracle 12C By: hakan_8 on Fri, 03 May 2019	4	664	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	848	Thu, 02 May 2019 09:54 By: cookiemonster
	Runtime data stored in tables By: hapr1 on Wed, 01 May 2019	1	387	Wed, 01 May 2019 18:19 By: BlackSwan
	Design Question 12c By: ora9a on Fri, 26 April 2019	17	1269	Wed, 01 May 2019 05:47 By: ora9a