This content has been marked as final. Show 3 replies
yes you can use sequence in a control file
an example would be:
LOAD DATA INFILE employee.csv APPEND INTO TABLE emp FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' (<column_name>, <column_name> DATE "DD-Month-YYYY", <column_name> CHAR TERMINATED BY ':', <column_name> SEQUENCE(MAX,1))
As an option to what Warren suggested, you can also specify an actual sequence name in the control file itself.
INTO TABLE <table_name>
FIELDS TERMINATED BY '|'