Example of regexp_replace function in select query

If you want use regexp_replace function with sql query then you can use following way.

select regexp_replace('abcd434574@#$%[5224]efgh','[^[:aln um:]@,%,]') from dual;
Output: abcd434574@%5224efgh