PL/SQL (MOSC)

MOSC Banner

CLOB String value replace or update

edited Aug 31, 2017 5:00AM in PL/SQL (MOSC) 7 commentsAnswered

Hi Experts,

I need help on CLOB string or element data replace and extraction from clob column table.

I need solution to replace the CLOB string or element value with XXXXX for element name address1, address2, address3,postal and MPPP etc.

Could you please suggest how could be this possible to replace and extract by using regexp, substr and DBMS_LOB functions or any other way.

for example, for data <address1>11 ASDFGHJ ASDF</address1>,
address1 value 99 ZZZZZZZ BBBBBBB replace with XXXXXXXXX. and same value (XXXX) would be required to replace for other CLOB strings (adress2, MPPP, POSTAL) value.

Here is extracted CLOB column data -

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center