Use the tool plsqldev to import Excel to the Oracle database, plsqldevoracle

Use the tool plsqldev to import Excel to the Oracle database, plsqldevoracle

1. Use the tool plsqldev

2. Open the excel file to be imported, click the office button, select Save As-other format, select Save type CSV (separated by commas) (*. csv), and click Save

3. Open plsqldev and select Text Importer under the Tools drop-down menu in the toolbar. Select the data from textfile tag. Click the button with a red line box below to open the csv file.

If it is successfully opened, select the "data to oracle" tab, select the owner and table, select the corresponding columns in the fields box, and select the corresponding column and type in the drop-down box on the right.

Click import.

(If the import button is gray, an error occurs)

How to import an excel table to oracle

Use PLSQL Developer.
1. In the SQL window of PLSQL Developer, enter select * from test for update;
2. Press F8.
3. open the lock, click the plus sign, click the column header in the first column, select the entire column, paste it, and submit the commit statement.

(Premise: Execl table structure is the same as that in Oracle)

How to import excel Data to ORACLE databases through PL/SQL

Insert a blank column at the beginning of excel. The first row is a column name.

Open in pl/SQL, edit data
Copy it in.