Hi, I'm using oracle 11g version .
I want to get only text as output (Ex: "oracle use" in the below query). I tried the below method and also googled but didn't find the solution. Could you please help in this regard.
with dat as (
select 'oracle use' s from dual
union all
select ' tes@t%* (' s from dual
union all
select '!#test' s from dual
union all
select '123556' s from dual
)
select * from dat
where regexp_like(s, '[^][[:alnum:]~!#@$%^&*()_+`={}|\;:''"<,>.?/-]');