Insert data into the database (ORACLE) through excel

Insert data into the database (ORACLE) through excel

We all know that PL/SQL can copy data to excel, and we can also insert data to the database through excel.

The following is a simple example and example.

First, create a table named test.

Create table test (

Id NUMBER

);

Run the following statement:

SELECT * FROM test for update;

And click the lock

Then we copy a column of numeric data in excel.

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

Click the Green Arrow <Strong? Http: www.bkjia.com kf ware vc "target =" _ blank "class =" keylink "> VcD4KPHA + kernel/yc3qs8nP8sr9vt2/4rLlyOtleGNlbLXEyv2 + kernel/CzbzL + cq + veG5 + zwvcD4KPHA + pgltzybzcm9 "http://www.2cto.com/uploadfile/Collfiles/20140918/2014091809240144.png" alt = "">