CLOB String value replace or update
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 -