create directory images as 'C:/images'; ---------------------------------创建一个目录名images
grant read on directory images to scott; ---------------------------------将images的读取权限付给当前用户scott;
declare
l_bfile BFILE;
l_blob BLOB;
begin
insert into test(image) values (empty_blob()) return image into l_blob;-----------------------插入一个emptyblob给test表的image字段并将其返回给l_blob变量
l_bfile := bfilename('IMAGES','/mypicture.jpg');
dbms_lob.open(l_bfile,dbms_lob.file_readonly);
dbms_lob.loadfromfile(l_blob,l_bfile,dbms_lob.getlength(l_bfile)); ----------------------将l_bfile指向的文件读入l_blob,也就将文件插入数据库中了
dbms_lob.close(l_bfile);
commit;
end;