The below error occurs with formatting following Create statement of an External Table using "date 'YYYYMMDD' " date mask parameter:
CREATE TABLE test5_ext
(
acct NUMBER (4)
, sub NUMBER (3)
, comment1 VARCHAR2 (20)
, comment2 VARCHAR2 (50)
, whatever VARCHAR2 (10)
, mydate DATE
)
ORGANIZATION EXTERNAL
(TYPE oracle_loader
DEFAULT DIRECTORY <dir name>
ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ","
MISSING FIELD VALUES ARE NULL
(acct , sub , comment1 , comment2 , whatever , mydate date 'YYYYMMDD' ))
LOCATION ('table.txt'));
[Error] Syntax check (18: 58): Found: 'date' Expecting: ) , -or- DEFAULTIF INTEGER NULLIF -or- ( BINARY_DOUBLE BINARY_FLOAT CHAR DECIMAL DOUBLE FLOAT ORACLE_DATE ORACLE_NUMBER RAW RECNUM UNSIGNED VARCHAR VARCHARC VARRAW VARRAWC ZONED -or- POSITION
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center