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	1	26901	Tue, 30 June 2020 11:23 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	46	292694	Thu, 21 April 2022 01:05 By: khawja_bilalahmed
query tunning has been moved to Performance Tuning by the moderator.
	Oracle flinding max plan id 19.8 By: Unclefool on Tue, 10 May 2022	1	6418	Wed, 11 May 2022 00:24 By: Michel Cadot
Excel 64 bit problem using has been moved to Windows by the moderator.
	partition non partioned table 12 c By: varunvir on Wed, 27 April 2022	10	12647	Thu, 28 April 2022 14:15 By: varunvir
	INSERT, SELECT CONNECT by 19.8 By: Unclefool on Tue, 26 April 2022	3	8999	Tue, 26 April 2022 14:45 By: Michel Cadot
	Remove unwanted characters 19c By: varunvir on Mon, 25 April 2022	4	9207	Tue, 26 April 2022 11:51 By: varunvir
	Query to create data instead of storing it 12.1.0.1.0 By: OraFerro on Mon, 25 April 2022	1	7751	Tue, 26 April 2022 05:31 By: OraFerro
	How to append a header on the top of the CSV file Oracle Database 19c Enterprise Edition Release 19.0.0.0.0, Windows 10 Pro By: buggleboy007 on Thu, 21 April 2022	2	10855	Sat, 23 April 2022 08:16 By: buggleboy007
	Is there a better way to do this in Oracle - Generate series with other entries Oracle >= 11.2 By: dragam on Thu, 14 April 2022	1	5457	Thu, 14 April 2022 09:05 By: Michel Cadot
	question on solution provided oracle 19c(19.0.0.0.0) By: manoj12 on Wed, 13 April 2022	0	6286	Wed, 13 April 2022 20:35 By: manoj12
	Help Needed in Oracle Referenced Column DataType oracle 19c By: born2achieve on Mon, 11 April 2022	3	6551	Tue, 12 April 2022 09:27 By: EdStevens
	Oracle JOIN tables Oracle 19.2 By: Unclefool on Mon, 11 April 2022	4	4224	Mon, 11 April 2022 14:35 By: Unclefool
	Find Difference between 2 columns along with difference data Oracle 12g By: abhayman on Thu, 31 March 2022	6	9148	Mon, 04 April 2022 02:04 By: piripicchio
	XML Generation Oracle 11g, XP By: rajiv.oradev on Thu, 17 March 2022	13	19163	Sat, 02 April 2022 14:21 By: Solomon Yakobson
	Data not sorted Oracle 19.2 By: Unclefool on Fri, 01 April 2022	2	8333	Fri, 01 April 2022 07:35 By: Unclefool
	Oracle Update to get data from other tables using join By: benoitS on Fri, 01 April 2022	2	8012	Fri, 01 April 2022 07:10 By: Solomon Yakobson
	Remove empty tags from XML Oracle 11g, XP By: rajiv.oradev on Thu, 31 March 2022	0	7323	Thu, 31 March 2022 15:33 By: rajiv.oradev
	ORA-01722 Invalid Number for numeric values. Oracle 12c By: Dhritman on Fri, 25 March 2022	9	8514	Fri, 25 March 2022 05:28 By: Solomon Yakobson
	DB last date 12.1.0.1.0 By: OraFerro on Wed, 23 March 2022	4	9693	Thu, 24 March 2022 07:34 By: EdStevens
	Code not waiting for REFCURSOR Oracle 12c By: IanC on Thu, 17 March 2022	5	11025	Tue, 22 March 2022 05:50 By: IanC
	Select Query suggestion Oracle 12c By: akssre on Tue, 15 March 2022	9	9644	Thu, 17 March 2022 05:22 By: Solomon Yakobson
	Pass a "Cursor XXXX is" statement to another procedure Oracle, 12.2, Unix By: Duane on Mon, 14 March 2022	3	6999	Tue, 15 March 2022 17:56 By: Solomon Yakobson
	Oracle calculate hours between timestamps 19.2 By: Unclefool on Thu, 10 March 2022	3	7591	Thu, 10 March 2022 17:30 By: EdStevens
	Let's promote them all ! 11.2.0.3 By: Amine on Fri, 18 February 2022	8	12105	Wed, 09 March 2022 15:01 By: Amine
	Help Needed in Date Variable By: born2achieve on Mon, 21 February 2022	1	11088	Tue, 22 February 2022 00:34 By: Michel Cadot
	Getting ORA-24374 , when using function in with query (merged) PLSQL 12.1.0.2.0 By: gopalMisra on Tue, 15 February 2022	13	8370	Mon, 21 February 2022 07:16 By: gopalMisra
	SQL -Report missing string when running a query Oracle 11 windows 10 By: Kevin1967 on Wed, 16 February 2022	4	5121	Sat, 19 February 2022 00:26 By: Michel Cadot
	Facing issie in 19c By: nishant87 on Thu, 17 February 2022	5	5586	Thu, 17 February 2022 08:16 By: EdStevens
	Putting a row with a particular value on top of a sort Oracle 21, Windows 10 By: orHooha on Wed, 09 February 2022	3	6660	Wed, 09 February 2022 20:59 By: orHooha
	query oracle11g By: Norfree on Wed, 02 February 2022	4	12244	Tue, 08 February 2022 06:49 By: Solomon Yakobson
	record count between one hour Oracle 19c By: bkbora on Fri, 04 February 2022	3	6309	Sun, 06 February 2022 06:21 By: Solomon Yakobson
	Oracle case INSERT statement 19.2 By: Unclefool on Fri, 04 February 2022	6	6039	Sat, 05 February 2022 09:14 By: EdStevens
	Print value in table columns dynamically By: dancko on Sun, 30 January 2022	5	15228	Wed, 02 February 2022 13:10 By: Michel Cadot
	ORA-04068: existing state of packages has been discarded Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Linux Redhat By: fixxxer on Fri, 30 August 2019	7	12110	Wed, 02 February 2022 03:38 By: fixxxer
	transpose logic oracle By: suji6281 on Tue, 25 January 2022	6	12291	Sat, 29 January 2022 18:31 By: Solomon Yakobson
	ORA 00922 MISSING OR INVALID OPTION ORACLE 12C , ORACLE FORMS AND REPORTS 12C By: lacchhii on Mon, 24 January 2022	2	5453	Tue, 25 January 2022 21:50 By: lacchhii
	Hex Value to Base64 Value Convertion SQL PL/SQL By: Khader Hussain on Mon, 24 January 2022	2	3058	Mon, 24 January 2022 03:30 By: Khader Hussain
	Dynamically pass table name in PLSQL Oracle client 18.0 By: 345678 on Sat, 22 January 2022	6	4662	Mon, 24 January 2022 03:16 By: 345678