Use PL/SQLDeveloper to import excel data to the database, plsqldeveloper

Use PL/SQLDeveloper to import excel data to the database, plsqldeveloper

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/45165707

An excel data table for an administrative division is shown as follows:

Save the file as a txt file as follows:

Use PL/SQL Developer to import data to oracle and find the Text importer option in the Tools column, as shown below:

Add the txt file path to the tool as follows:

Perform the following settings:

Click Import to Import data.

 

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/45165707