create or replace directory data_dir as '/app/oracle/admin/gsweb/bdump/'
/

-- copy dm_hz.csv to $oracle_base/admin/gsweb/bdump/
create table dm_hz
( 
hz varchar2(10) ,
py varchar2(10) ,
sd varchar2(10) ,
wb varchar2(10) ,
yxbz varchar2(10) 
)
organization external
(type oracle_loader
default directory data_dir
access parameters
(
records delimited by newline
fields terminated by ','
missing field values are null
( hz ,
py,
sd,
wb ,
yxbz 
)
)
location ('dm_hz.csv')
)
/

@create_fun_get_hz_py.sql

ok .end.