demo14.sql

来自「VC++是微软公司开发的一个IDE(集成开发环境),换句话说,就是使用c++的一」· SQL 代码 · 共 16 行

create table t
( id       int primary key,
  os_file  bfile
)
/
create or replace directory my_dir as '/tmp/'
/
insert into t values ( 1, bfilename( 'MY_DIR', 'test.dbf' ) );
select dbms_lob.getlength(os_file) from t;
update t set os_file = bfilename( 'my_dir', 'test.dbf' );
select dbms_lob.getlength(os_file) from t;
create or replace directory "my_dir" as '/tmp/'
/
select dbms_lob.getlength(os_file) from t;