一、plsql创建外部表代码create table table_name
(
a1 VARCHAR2(300),
a2 VARCHAR2(300),
a3 VARCHAR2(300),
a4 VARCHAR2(300),
a5 VARCHAR2(300),
a6 VARCHAR2(300),
a7 VARCHAR2(300),
a8 VARCHAR2(300),
a9 VARCHAR2(300),
a10 VARCHAR2(300),
a11 VARCHAR2(300),
a12 VARCHAR2(300),
a13 VARCHAR2(300),
a14 VARCHAR2(300),
a15 VARCHAR2(300),
a16 VARCHAR2(300),
a17 VARCHAR2(300),
a18 VARCHAR2(300),
a19 VARCHAR2(300),
a20 VARCHAR2(300),
a21 VARCHAR2(300),
a22 VARCHAR2(300),
a23 VARCHAR2(300),
a24 VARCHAR2(300),
a25 VARCHAR2(300),
a26 VARCHAR2(300),
a27 VARCHAR2(300),
a28 VARCHAR2(300),
a29 VARCHAR2(300)
)
organization external
(
type ORACLE_LOADER
default directory SOURCE_DIR
access parameters
(
records deli