Skip to Main Content
Forums

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!

REGEXP_REPLACE: How to replace a list of words to null

625417Feb 26 2008 — edited Feb 29 2008
Hi,

I need to replace if any word (from the list of words) is occoured in the given string, to null.

I have tried the following:

SELECT REGEXP_REPLACE(FIELD_NAME, 'and', '') AS RX_REPLACE FROM SAMPLE_TABLE;

But it not working as expected.

Your help is really appreciated on this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2008
Added on Feb 26 2008
11 comments
18,181 views