Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.
Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/45165707
For example an administrative division of the Excel data table, as follows:
Save the file as a txt document as follows:
Using PL/SQL Developer to import data into Oracle , find the Text importer option in the Tools bar as follows:
Add the txt file path to the tool, as follows:
Make the relevant settings as follows:
Click The Import button to complete the import of the data.
Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.
Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/45165707
Import Excel data into a database using Pl/sqldeveloper