--写blob DECLARE lobloc BLOB; buffer VARCHAR2(2000); amount NUMBER :=20; offset NUMBER :=1; BEGIN --初始化要写入的数据 buffer :='aaaaaaaaa'; amount := length(buffer); SELECT content INTO lobloc -- 获取定位器并锁定行 FROM tb_productaccessory WHERE id =-1FORUPDATE; dbms_lob.write(lobloc,3,1,buffer); COMMIT; END;
--读blob declare lobloc BLOB; buffer VARCHAR2(2000); amount NUMBER :=2; offset NUMBER :=1; BEGIN SELECT content INTO lobloc --获取定位器 FROM tb_definition_myself_accessory WHERE id =-105; dbms_lob.read(lobloc,amount,offset,buffer);--读取数据到缓冲区 dbms_output.put_line(buffer);--显示缓冲区中的数据(显示的ASII玛字符) --SELECT content INTO lobloc -- 获取定位器并锁定行 --FROM tb_definition_myself_accessory --WHERE id = -2 FOR UPDATE; dbms_lob.write(lobloc,2,1,buffer); commit; END;