–1,建立含有bfile的列表
create table lob_ex3 (
id number(4) primary key,
name varchar2(20),
resume bfile
);
–2,初始化bfile列
/*
bfilename (‘目录名’,’文件名’) 函数
*/
create or replace directory BFILE_DIR as ‘D:\bfile’;
select * from dba_directories;
insert into lob_ex3 values (1,’王瑶’,bfilename(‘BFILE_DIR’,’王瑶.txt’));
insert into lob_ex3 values (2,’梁涛’,bfilename(‘BFILE_DIR’,’梁涛.txt’));
select * from lob_ex3;
–3,读取bfile列的内容
declare
fileloc bfile;
dest_offset int := 1;
v_acount int ;
buffer varchar2(200);
begin
select resume into fileloc from lob_ex3 where id =1 ;
dbms_lob.fileopen(fileloc,0);
v_acount:= dbms_lob.getlength(fileloc);
dbms_lob.read(fileloc,v_acount,1,buffer);
dbms_lob.fileclose(fileloc);
end;