PL/SQL How do I import Excel file data into Oracle's data tables?

1. Excel file for importing data

Note: Excel column names and data table column names must be the same, and Excel files Sheet2 and Sheet3 can be deleted

1) Excel file format

2) Data table format

2. Open PL/SQL, find tools---> ODBC importer

3. Select Excel file, enter user/password

4. Click Connect to find the file you want to import on the disk

5. Select the sheet to import the file Sheet1

6. Switch to Oracle and select the table you want to import into Oracle

7. Click Import, execute success, view results

PL/SQL How do I import Excel file data into Oracle's data tables?