找了一下,呵呵,发现个例子:
CREATE TABLE (first_name CHAR(15), last_name CHAR(20), year_of_birth CHAR(4))
ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_dir
ACCESS PARAMETERS (RECORD FIXED 20 FIELDS (first_name CHAR(7),
last_name CHAR(8),
year_of_birth CHAR(4))
LOCATION ('foo.dat'));
File:
AlvinTolliver1976
KennethBaer1963
Mary Dube1973
还没测过~~
|