Use PLSQL developer to import and export Excel table data from Oracle Database

Export data to an Excel file: select the data table -- query data -- select the data to be exported -- Right-click Copy to excel to import data to the database: 1. Prepare the data to be imported in Excel. Specific Operation: In Excel, set the first column as an empty column. The columns after the second column should correspond to the fields of the data table to be imported. 2. log on to PLSQL developer, find the database table for which you want to import data, right-click -- edit data, enter the data edit table dialog box, and click an empty row on the left. 3. copy the data records in the Excel table and paste the data into the table column displayed by PLSQL developer in the previous step. 4. Click "Post" in PLSQL developer.