Forum Stats

  • 3,827,511 Users
  • 2,260,787 Discussions
  • 7,897,282 Comments

Discussions

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

User_GRHMY
User_GRHMY Member Posts: 1 Green Ribbon
edited May 18, 2022 4:33PM in General Database Discussions

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.

Answers