Import excel Data to oracle and data to oracle

Import excel Data to oracle and data to oracle

If you want to import excel data to an oracle table, the columns in excel are the same as those in the oracle table. The content and table in excel are as follows:

Copy and paste the excel content to the oracle table. You do not need to install other software or configure any files. The procedure is as follows:
1. Execute select * from tableName for update in plsql
2. Click the oracle lock type to unlock the database, for example:

3. Click and select the first planet number, and copy and paste the excel content. Effect:

4. Remember to use commit.

Note: 1. The column order in excel is the same as that in table fields.
2. Since the table structure is different from the column order in excel at the beginning, I adjusted the order of the excel columns myself, so the first column must be blank when I copy the excel content, in addition, you must copy the blank space.

Note: For project confidentiality, I have changed all the actual values of dept and cityid.