存clob的值

DECLARE
  v_clob CLOB;
BEGIN
   v_clob :='ADCO01,ADCO08,ADCO09,ADCO11,ADCO12,ADCOC0,ADFT01,ADFT03,ADFTC0,ADHF02,ADHF05,ADHF07';
   
   --清空
   --UPDATE T05_PROBLEM_AUTHORITY t  SET t.STORE_AT_GUID2 = empty_clob();
   
   --更新
   --UPDATE T05_PROBLEM_AUTHORITY t  SET t.STORE_AT_GUID2 = v_clob;
   COMMIT;
END;

原文地址:https://www.cnblogs.com/BruceDu/p/7389908.html