17,377
社区成员
发帖
与我相关
我的任务
分享
insert into t_blob values ('tom',utl_raw.cast_to_raw('tom is a good boy!'));
select stuname,utl_raw.cast_to_varchar2(dblob) from t_blob;
STUNAME
--------------------
UTL_RAW.CAST_TO_VARCHAR2(DBLOB)
----------------------------------------------------------------------------------------------------
tom
tom is a good boy!
Declare
b_c Blob;
Begin
select dblob Into b_c From t_blob For Update;
dbms_lob.append(b_c,utl_raw.cast_to_raw('and you?'));
Update t_blob
set dblob = b_c;
End;
--commit;
select utl_raw.cast_to_varchar2(dblob) from t_blob;
UTL_RAW.CAST_TO_VARCHAR2(DBLOB)
---------------------------------------------------------------------
tom is a good boy!and you?
--估计要改下 ||这个应该是对字符型有效的
update a set xx=utl_raw.cast_to_raw(utl_raw.cast_to_varchar2(xx)||'aa')
--这样试试
update a set xx=xx|| utl_raw.cast_to_raw('aa')