您现在正在浏览：站长之家 >> 数据库 >> 详细内容

如何使用Oracle的BFILE

时间:2007-12-23 来源:不详作者:迈克DB

Elapsed: 00:00:00.03
SQL> insert into lunar_test values ( 1, bfilename ( 'BFILE_DIR', 'bfiletest_file.txt' ) );

1 row created.

Elapsed: 00:00:00.00
SQL> commit;

Commit complete.

Elapsed: 00:00:00.00
SQL> 织梦好，好织梦

内容来自dedecms

declare
fhandle utl_file.file_type;
begin
fhandle := utl_file.fopen('BFILE_DIR', 'lunartest1.txt', 'w');
utl_file.put_line(fhandle , 'aaa');
utl_file.put_line(fhandle , 'bbb');
utl_file.fclose(fhandle);
end;
/ 内容来自dedecms

declare
fhandle utl_file.file_type;
fp_buffer varchar2(4000);
begin
fhandle := utl_file.fopen ('BFILE_DIR','lunartest1.txt', 'R');

utl_file.get_line (fhandle , fp_buffer );
dbms_output.put_line(fp_buffer );
utl_file.get_line (fhandle , fp_buffer );
dbms_output.put_line(fp_buffer );
utl_file.fclose(fhandle);
end; 织梦好，好织梦

织梦好，好织梦