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	38924	Tue, 30 June 2020 11:23 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	47	337125	Sun, 29 January 2023 19:35 By: mathguy
How to create menu using database table (2 topics merged, duplicate deleted, moved to Forms by bb) has been moved to Forms by the moderator.
	Get the MetaData for FGA Policy Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Tue, 14 May 2024	3	5037	Thu, 16 May 2024 14:18 By: wtolentino
	previous month oracle By: Sekhar6617 on Mon, 13 May 2024	4	5034	Tue, 14 May 2024 04:05 By: cookiemonster
	ORA-30372: fine grain access policy conflicts with materialized view Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Fri, 10 May 2024	4	7443	Sun, 12 May 2024 16:47 By: wtolentino
	PL SQL table generate auto index Oracle 19C By: sss111ind on Wed, 01 May 2024	3	16805	Wed, 01 May 2024 09:36 By: Barbara Boehmer
	insert data from csv file oracle 19c, windows 11 By: jimut on Mon, 29 April 2024	2	19678	Mon, 29 April 2024 04:11 By: Barbara Boehmer
	Missing records Oracle SQL By: ace_friends22 on Wed, 24 April 2024	3	15814	Wed, 24 April 2024 10:13 By: ace_friends22
	Condition based truncate partition Oracle By: ace_friends22 on Fri, 22 December 2023	3	29793	Wed, 24 April 2024 10:09 By: ace_friends22
	Convert input from user into UPPERCASE Oracle SQL By: watisditnou@msn.com on Tue, 16 April 2024	6	13750	Wed, 24 April 2024 03:34 By: John Watson
	Getting ancestors in hierarchies 11.2.0.3.0 By: Amine on Sat, 20 April 2024	7	6745	Mon, 22 April 2024 08:19 By: Amine
	Oracle ORA-00918: column ambiguously defined 19c By: Unclefool on Tue, 16 April 2024	14	9471	Wed, 17 April 2024 17:31 By: Barbara Boehmer
	correct treatment of date across different timezones Oracle 19 By: jansulc on Thu, 04 April 2024	5	12881	Thu, 04 April 2024 06:27 By: jansulc
	Implement Profile, PW Policy & Roles Oracle SQL Developer (XE) - By: noname369 on Tue, 02 April 2024	7	13787	Wed, 03 April 2024 11:02 By: Michel Cadot
	RETUNR FUNCTION USING "TYPE" 10G By: emadnabil on Thu, 22 February 2024	3	23530	Fri, 29 March 2024 07:08 By: emadnabil
	Getting same sequence number in select query Oracle 19c By: sss111ind on Tue, 12 March 2024	7	21093	Wed, 27 March 2024 12:12 By: Solomon Yakobson
	how to sum the amounts By: suji6281 on Tue, 26 March 2024	6	16581	Tue, 26 March 2024 09:56 By: suji6281
	Do users ever create tables in these schemas? 18 By: Darth Waiter on Sun, 17 March 2024	18	14770	Wed, 20 March 2024 12:22 By: cookiemonster
	Prevent user from executing a script until they will have read and understood it 18 By: Darth Waiter on Fri, 08 March 2024	7	18474	Tue, 12 March 2024 14:03 By: Darth Waiter
	BLOB Column with Zip File Convert to CLOB Oracle, 19.0.0.0.0, Linux By: Duane on Tue, 20 February 2024	9	15820	Fri, 01 March 2024 10:44 By: Michel Cadot
	update table attribute help! By: ramys on Thu, 22 February 2024	3	16417	Thu, 22 February 2024 21:57 By: flyboy
	Query having multiple subqueries to be simplified 11g enterprise version By: harishankar_kar on Tue, 20 February 2024	6	9690	Wed, 21 February 2024 04:34 By: cookiemonster
	Help needed in Tricky Group by oracle 19c By: born2achieve on Mon, 19 February 2024	2	3024	Tue, 20 February 2024 10:13 By: born2achieve
	Traverse CLOB with Connect By Oracle, 19.0.0.0.0, Linux By: Duane on Thu, 15 February 2024	25	17652	Sat, 17 February 2024 11:03 By: Duane
	Read BLOB from Table into CLOB for further processing Oracle, 19.0.0.0.0, Linux By: Duane on Tue, 13 February 2024	9	9122	Wed, 14 February 2024 13:26 By: Duane
	Xmlattribute not returning tag when the value is null Oracle 19c By: sss111ind on Fri, 09 February 2024	5	10014	Wed, 14 February 2024 03:08 By: sss111ind
	Creating Global vs Local Indexes for Partitioned Table ORACLE 19c By: oracle_search on Tue, 13 February 2024	4	7953	Wed, 14 February 2024 02:35 By: John Watson
	Querying table permissions to see which users have them 18 By: Darth Waiter on Mon, 05 February 2024	12	9323	Thu, 08 February 2024 13:49 By: Darth Waiter
	Dad, Grand Pa and Great Grand Pa ! 11.2.0.3 By: Amine on Fri, 09 December 2022	7	45574	Wed, 07 February 2024 10:35 By: Amine
	oracle10g and utl_http oracle10g By: aabunarr on Sat, 03 February 2024	2	11527	Sun, 04 February 2024 09:25 By: Frank Naude
	Evaluating a sys_context call in a predicate DB 19.22 By: John Watson on Wed, 31 January 2024	3	13983	Sat, 03 February 2024 02:13 By: John Watson
	What is the difference between varchar2 and nvarchar2? Oracle 18 Windows Server 2016 By: Darth Waiter on Wed, 24 January 2024	10	23296	Sat, 27 January 2024 20:51 By: mathguy
	DBMS_OUTPUT how to include a white space Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.21.0.0.0 By: wtolentino on Thu, 25 January 2024	2	18292	Thu, 25 January 2024 11:15 By: Michel Cadot
	VSIZE() function's meaning and physical storage size 18 By: Darth Waiter on Wed, 17 January 2024	12	20980	Fri, 19 January 2024 11:04 By: Darth Waiter
	Need help to build a query Oracle12C By: shabir46 on Wed, 17 January 2024	1	14670	Wed, 17 January 2024 12:12 By: Michel Cadot
	XML Create logic By: vips2988 on Wed, 10 January 2024	3	15787	Thu, 11 January 2024 19:20 By: mathguy
	Grants of System Privileges Thru Stored Procedure Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.21.0.0.0 By: wtolentino on Tue, 09 January 2024	2	12699	Tue, 09 January 2024 09:28 By: wtolentino
	plsql writen test questions oracle 18 By: bammidi on Sun, 07 January 2024	4	14655	Mon, 08 January 2024 09:07 By: bammidi
	Partition 19c By: babuknb on Thu, 07 December 2023	6	27120	Sun, 07 January 2024 12:26 By: babuknb