PL/SQL Import Excel table to Oracle Datasheet

by using PL/SQL bulk query fetching, each column of data in Excel is copied and pasted into the new intermediate table, which is sticky when pasted, that is, some columns will be inserted into the whole column from the second third row, causing the data to be confused, and then it does not support the bulk deletion of the entire column of data, So it's the best way to import an entire Excel table at once.

The first step:

Select all of the data in Excel that you want to insert into Oracle: ( must be checked or not in the database )

Step Two:

Then save as: text file (Tab delimited) (*.txt)

Step Three:

Then go to the PL/SQL Selection Tool-text importer

Fourth Step:

To make a file selection:

Fifth Step:

When you select a file, the following interface appears, and you can see the results preview

Sixth step:

Click "Data to Oracle", select the table owner and table name, you can see the name of the table header in Excel, corresponding to select the corresponding field

Seventh Step:

Click Import, it's all right.

PL/SQL Import Excel table to Oracle Datasheet