1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| create table xtern_table
( ID_VILLE varchar2(6),
VILLE varchar2(50),
DATE_QVB date,
CODE1 number(8,2),
CODE2 number(8,2),
CODE3 number(5),
CODE4 number(2,1)
)
organization external
( default directory xtern_data_dir
access parameters
( records delimited by newline
fields terminated by ';'
( ID_VILLE char(6),
VILLE char(50),
DATE_QVB char(19) date_format DATE mask "Mon DD YYYY HH:MIAM",
CODE1 char(8),
CODE2 char(8),
CODE3 char(4),
CODE4 char(1)
)
)
location ('fic.csv')
)
/ |
Partager