Asp.net,PL/SQL tips-Tricks for error resolution version 2014,2012,2008,2005,Procedural language,Stored Procedure, computer , excel macro programming,Visual Studio,Film,Musical notations,Indian ,Western Music.

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