17,377
社区成员
发帖
与我相关
我的任务
分享
--上次做了测试 10g下
create table t_blob(stuname varchar2(20),dblob blob);
scott@YPCOST> ed
已写入 file afiedt.buf
1* insert into t_blob values ('tom',utl_raw.cast_to_raw('tom is a good boy!'))
scott@YPCOST> /
已创建 1 行。
scott@YPCOST> select stuname,utl_raw.cast_to_varchar2(dblob) from t_blob;
STUNAME
--------------------
UTL_RAW.CAST_TO_VARCHAR2(DBLOB)
----------------------------------------------------------------------------------------------------
tom
tom is a good boy!
scott@YPCOST> update t_blob set dblob=utl_raw.cast_to_raw('tom is not a good boy!') where stuname='t
om';
已更新 1 行。
scott@YPCOST> commit;
提交完成。
scott@YPCOST> select stuname,utl_raw.cast_to_varchar2(dblob) from t_blob;
STUNAME
--------------------
UTL_RAW.CAST_TO_VARCHAR2(DBLOB)
----------------------------------------------------------------------------------------------------
tom
tom is not a good boy!