I am using oracle 11g xe edition.
probably school boy error but i cant' see it
Error at Command Line : 21 Column : 12
Error report -
SQL Error: ORA-00906: missing left parenthesis
create table rgc_ext
(
forename VARCHAR2(20),
surname vARCHAR2(20)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY rgc
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS
(
forename VARCHAR2(20),
surname vARCHAR2(20),
dob sate
)
)
LOCATION 'info.csv'
);