先检索到它的定位器:
declare
v_blob blob;
v_buffer varchar2(2000);
begin
select col_blob into v_blob
from table_blob
where ...
for update;
dbms_lob.writeappend(v_blob,10,'1234567890');--写入数据
dbms_lob.write(v_blob,10,11,'ddfdfdddddd');--替换数据
dbms_lob.read(v_blob,2000,1,v_buffer);
dbms_output.put_line(v_buffer);
end;
declare
v_blob blob;
v_buffer varchar2(2000);
begin
select col_blob into v_blob
from table_blob
where ...
for update;
dbms_lob.writeappend(v_blob,10,'1234567890');--写入数据
dbms_lob.write(v_blob,10,11,'ddfdfdddddd');--替换数据
dbms_lob.read(v_blob,2000,1,v_buffer);
dbms_output.put_line(v_buffer);
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货