oracle存储clob海量文本,采用append的方式

xiaoxiao2021-02-28  96

-- sql declare temp_image clob default empty_clob(); image2 clob default empty_clob(); begin image2 := 'data:image/png;base64,'; temp_image := 'abc...(less then 32767 character)'; dbms_lob.append(image2, temp_image); temp_image := 'def...(less then 32767 character)'; dbms_lob.append(image2, temp_image);   Insert into DM_BASE_DATALOGO (ID,IMAGE) values (2, image2);   COMMIT;  end; /
转载请注明原文地址: https://www.6miu.com/read-60321.html

最新回复(0)