Код: Выделить всё
CREATE TABLE axp_plan1
(opy NUMBER
,last2 VARCHAr2(2)
)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY smetadir
ACCESS PARAMETERS (RECORDS DELIMETED BY NEWLINE
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
FIELDS (opy number(5)
,last2 VARCHAR2(2)
)
)
location ('ххх.dat')
)