NC轻量级二进制备注与字符串互转

来源：互联网发布：php基础知识视频编辑：程序博客网时间：2024/05/20 07:53

二进制分析：

二进制转字符串方法

create or replace function f_blob2char(v_blob in blob) return varchar2 is  v_result varchar2(4000);begin  select CONVERT(UTL_RAW.CAST_TO_VARCHAR2(Dbms_Lob.Substr(v_blob,length(v_blob)-7,8)),'ZHS16GBK','UTF8') into v_result from dual;  return(v_result);end f_blob2char;

字符串转二进制方法

create or replace function f_char2ncblob(v_char2 in varchar2) return blob is  b_t_result      blob;  b_result        blob;  b_length        blob;  v_length        varchar(2000);  v_char3         varchar(2000);begin  v_char3 := replace(v_char2,'\n',chr(13));  select to_blob(UTL_RAW.CAST_TO_RAW(CONVERT(v_char3,'UTF8','ZHS16GBK'))) into b_t_result from dual;  v_length := 'ACED000574' || replace(to_char(length(b_t_result),'XXX'),' ','0');  b_length := to_blob(v_length);  dbms_lob.append(b_length,b_t_result);  return(b_length);end f_char2ncblob;

1 0