Asp.net,PL SQL Tips for error resolution,Research,Development,SQL 2014,2012,2008,Procedural language,SP,excel macro ,Musical notations.

October 20, 2012

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