Inserting data into the database (ORACLE) via Excel

We all know that PL/SQL can copy data to Excel, and we can also insert data into the database via Excel.

Let's take a simple example with a demo

First, we create a table test

CREATE TABLE Test (

ID number

);

Then we execute the following statement

SELECT * from test for UPDATE;

and open the lock.

Then we copy a column of numeric data in Excel.

Select the column name id,ctrl+v in the PL/SQL query results to paste the above data

Click on the green Arrow

and commit commits to complete the task of inserting Excel data into the database

Execute Selext * from test; get results as shown

Inserting data into the database (ORACLE) via Excel