{外部表}delimited by '|'でデータ長を指定した外部表を作成

 

https://docs.oracle.com/cd/F19136_01/sutil/oracle_loader-access-driver.html#GUID-91CC2060-FA18-4246-BC3F-82154FF4FA5B

vi info3.dat
Alvin,Tolliver,1976,|Kenneth,Baer,1963,|Mary,Dube,1973,

CREATE TABLE test.ext_delimited (first_name CHAR(15), last_name CHAR(20), year_of_birth CHAR(4))
  ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY ORA_DIR
                         ACCESS PARAMETERS (RECORDS DELIMITED BY '|' FIELDS TERMINATED BY ','
                                              (first_name CHAR(7),
                                               last_name CHAR(8),
                                               year_of_birth CHAR(4)))
                         LOCATION ('info3.dat'));

select * from test.ext_delimited;