select regexp_replace('{"title":"The cow jumped over the moon", "description":"the Dog chased the cat"}', '([:]\s*\")[^\"]*(cow jumped|dog)[^\"]*',
':"*****', 1, 0, 'i')
from dual| REGEXP_REPLACE('{"TITLE":"THECOWJUMPEDOVERTHEMOON","DESCRIPTION":"THEDOGCHASEDTHECAT"}','([:]\S*\")[^\"]*(COWJUMPED|DOG)[^\"]*',':"*****',1,0,'I') | {"title":"*****", "description":"*****"} |
|---|