Software Applications Programming Errors and solutions.

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