PL/SQL data import and export talk (1)

The recent need to guide data through PL/SQL to Oracle will summarize

Sample table: Test

field: id;name;org;

1, direct copy and paste (when the amount of data is not particularly large)

1) using the SELECT * from test for UPDATE statement

2) After the execution, click the small lock in the upper left of the Query Results window, open, you can copy and paste under the corresponding fields

3) After the paste is finished, click on the checkmark. You can then commit the transaction.

Advantages: Convenient

Cons: Accuracy is prone to error when data volume is larger

2. Using the PL/SQL self-bring tool

1) Prepare the data and save the Excel file you want to import as a txt or a CVS file

2) in the toolbar, select Tools--Text importer

3. Click "Data from Text file" above to open the button and browse to the file you want to import.

4) Configure each field at the configuration point and Note the setting of the field at the end of the fields

5) Click the "Data to Oracle" tab on the right of "data from text files" After configuration is complete

6) Select the table name in the "Data to Oracle" tab and the amount of data submitted per commit

7) Configure the field at the field and select the appropriate data type in the field type on the right

8) Click Import

Note: When importing with a CSV file, be aware of the Terminator at the end of the last field