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 27
| COL sdate new_value sdate
SELECT to_char(sysdate,'YYYYMMDD') sdate
FROM dual;
CREATE TABLE IC&sdate
(
champs1 VARCHAR2(100),
champs2 VARCHAR2(100),
champs3 VARCHAR2(100),
champs4 VARCHAR2(100),
champs5 VARCHAR2(100),
champs6 VARCHAR2(100)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY LOG_EXCHANGER
ACCESS PARAMETERS
(
records delimited BY newline
FIELDS terminated BY X"09"
missing FIELD VALUES are NULL
)
LOCATION ('&sdate..txt')
)
PARALLEL
REJECT LIMIT UNLIMITED; |
Partager