Use PLSQL Developer to import and export excel table data from oracle Database

Use PLSQL Developer to import and export excel table data from oracle database to excel file: www.2cto.com execute the query statement, query the data to be exported, and select them (right-click select All) -- Right-click copy to excel, but note that if the data volume is large, do not exceed the maximum allowed number of rows; otherwise
If the data exceeds the limit, you can only export the excel data to the database multiple times: 1. Prepare the data to be imported in Excel. Specific Operation: In Excel, set the first column to an empty column, and then the second column
Corresponding to the fields of the data table to be imported. Www.2cto.com 2. log on to PLSQL Developer, find the database table for data import, right-click -- edit data, and edit
In the data dialog box of the table, click the left-side Navigation Pane to select an empty row. 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. Note: PLSQL Developer does not know "-"