Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_GRHMYMay 18 2022 — edited May 18 2022

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.

Added on May 18 2022

#excel, #general-database-discussions, #import, #sqldeveloper

1 comment

1,727 views