How to remove Special character given a string with and without using REGEXP_REPLACE function - SQL
Select REGEXP_REPLACE('Jaga&thes&an#nsit$£€@gmail. Com', '[^a-zA-Z0-9@ ]', '') from dual
select replace(replace(replace(replace(replace(replace(name,'&',''),'#',''),'$',''),'£',''),'€',''),' ','')from test1