ORACLE CLOB LIKE ,REPLACE

1.CLOB LIKE 검색

 

SELECT * FROM 테이블이름

WHERE DBMS_LOB.INSTR(CLOB필드명, '검색어' ) > 0;   

 

2.CLOB REPLACE

 

EGEXP_REPLACE(FORM_HTML,STR1,STR2)

 

update table 명 

set form_html = regexp_replace(form_html,'http//:','https://')
 WHERE DBMS_LOB.INSTR(form_html,'http://')>0; 

[출처] ORACLE CLOB LIKE ,REPLACE|작성자 몽상가