Use PL/SQLDeveloper to import CSV data to the corresponding ORACLE table

CSVComma Separated values is a plain text file format used to store data. It is usually used for workbooks or database software. We can usePL/SQLDeveloperTools import CSV dataOracle DatabaseCorresponding table.

Condition: when a single file is small (less than 100000 rows) and the target table structure already exists-for excel, because the maximum behavior of an excel file is 65536-you can select all data copies and then use the PL/SQLDeveloper tool.

The import process is as follows:

1. In the SQL window of PL/SQLDeveloper, enter select * fromtestforupdate;

2. Press F8;

3. open the lock and click the plus sign. Click the column header in the first column to make the entire column select, Then PASTE, and finally submit the COMMIT.

Following the preceding three steps, you can import the CSV data to the table in the Oracle database.