Use PL/SQL Developer to import Excel Data

Using PL/SQL Developer to import Excel data often involves data migration after project delivery. Generally, the given data does not have an ID, that is, the primary key. you need to add a column in excel, such as ID. save the excel file as a Text (Tab delimited) file, open plsql, connect to the oracle database to be imported, and then open Tools --> Text importer... --> Open data file: select the txt file to be imported and set general configuration. If the excel data has a header, check the name in head. set Field End. if you need data conversion when setting Fields with the tab key as the column separator, you can use the SQL function, which is a function provided by Oracle or you can write it yourself.