Posts

Showing posts from June, 2019

White Space is not allowed

I had to replace REGEXP_REPLACE to regular REPLACE like below. Code: REPLACE(v_value, '&', '&'||'amp;'); I found the solution from this link. https://cloudcustomerconnect.oracle.com/posts/8e55f4748c