Sql developer blob类型的数据更新和插入

CREATE OR REPLACE DIRECTORY “IMAGE” AS ‘E:\image’;
–image为新建目录
DECLARE
B_LOB BLOB;
F_LOB BFILE := BFILENAME(‘IMAGE’, ‘9787302473671.jpg’);
BEGIN
–插入时，在这将更新语句换为插入语句即可
UPDATE BOOKS SET IMG = EMPTY_BLOB() WHERE ID = ‘9787302473671’
–BOOKS是包含blob类型的表,IMG为图片列
RETURNING IMG INTO B_LOB;
DBMS_LOB.FILEOPEN(F_LOB);
DBMS_LOB.LOADFROMFILE(B_LOB, F_LOB, DBMS_LOB.GETLENGTH(F_LOB));
DBMS_LOB.FILECLOSE(F_LOB);
COMMIT;
END;
/