How do I import data from Excel file using SQL Developer using the autonumber for the sequence ID?

User_GRHMY

I have a file with my data and the fields: sy_id, inst_id, bld_num, project_num, created_by, etc.

I have an ID in the table and want to the ID to autonumber for every record imported. Also, I want the date_created to auto populate as the data is inserted into the table.

Mike Kutz

Either create a TRIGGER or define a DEFAULT on the target table.

Alter table target_table
Modify (date_inserted default on null sysdate
,id default on null seq.nextval )