1.Long Raw转Blob
create table notice_info_bak as
select to_lob(t.content) as content_blob from notice_infot;
2.Blob转Clob
CREATE OR REPLACE FUNCTION blob_to_clob(blob_inINBLOB) RETURN CLOB AS
v_clob CLOB;
v_varchar VARCHAR2(32767);
v_start PLS_INTEGER:=1;
v_buffer PLS_INTEGER:=32767;
tmp_num number;
BEGIN
DBMS_LOB.CREATETEMPORARY(v_clob,TRUE);
tmp_num := CEIL(DBMS_LOB.GETLENGTH(blob_in) / v_buffer);
if tmp_num > 0 then
‐‐防止传入的BLOB为NULL或长度为0时引发错误
FOR i IN 1 … tmp_num LOOP
v_varchar:=UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(blob_in,v_buffer,v_start));DBMS_LOB.WRITEAPPEND(v_clob,LENGTH(v_varchar),v_varchar);v_start:=v_start+v_buffer;ENDLOOP;endif;RETURNv_clob;ENDblob_to_clob;/
selectblob_to_clob(T.content_blob)BBBfromnotice_info_bakt
Long Raw转Clob
最新推荐文章于 2021-06-03 09:25:35 发布