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

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.