SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I want to remove bind variables in my data like & and many

user13034857Oct 30 2013 — edited Oct 30 2013

I have a field that holds description of a code and this is having bind variables (special characters). I need to remove them and replace with no value.

I was trying with following sql and the dialog box (Enter Substitution Variable)is opening when I tried to execute the sql.

select regexp_replace('B VOC AC & HEATING (*[[:punct:]])', '') from dual;

please provide me the SQL how to do this

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2013

Added on Oct 30 2013

2 comments

2,458 views