oracle实验-BFILE的用法

BFILE的用法

(1)、create or replace directory
BFILE_TEST
as
'/oracle/oradata/bfiles';

(2)、grant read on directory BFILE_TEST to SCOTT;

(3)、host ls -l /oracle/oradata/bfiles/1.TXT

(4)、connect SCOTT/TIGER
create table BFILES (ID number, TEXT bfile );

(5)、insert into BFILES values ( 1,
bfilename ( 'BFILE_TEST', '1.TXT' ) );



create directory ww as 'd:\ww' --- 建立对应O RACLE文件夹

create table filelist(id varchar2(2), bf bfile,bb blob);---建表

insert into filelist values ('1',bfilename('ww','ss.txt'),'')---存入文件指针
问一下,这里的文件名需要带后缀名吗?(SS OR SS.TXT)




declare
  b blob;
  fb bfile:=bfilename('ww','ss.txt');
begin
  select bb into b from sy where id='1' for update;
  
  if(dbms_lob.fileexists(fb)!=0)
  then
  dbms_lob.open(b,dbms_lob.lob_readwrite);
  dbms_lob.open(fb,dbms_lob.lob_readonly);
  dbms_lob.loadfromfile(b,fb,dbms_lob.getlength(fb));
  dbms_lob.close(fb);
  dbms_lob.close(b);
  commit;
  end if;
  EXCEPTION
  when others then
  dbms_output.put_line('falid');
end;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7551038/viewspace-614385/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7551038/viewspace-614385/