How to import an Excel file to an Oracle database:
1. You can use select * from table name for update
Then unlock the lock and copy and paste the data in the Excel file.
Note that an empty column must be reserved before copying. Otherwise, a string column will be reserved.
Second, convert to TXT and use sqlload for warehouse receiving.
1. Save the Excel file as a TXT file, and select the Unicode text format (* .txtformat, named 11.txt ).
2 In this case, the data in the 11.txt file is separated by tabs. In this case, you need to replace the tab with a separator recognized by sqlload.
3. open the file 11.txt In the word' open-square format, and you will see the form of word.
4. Replace '^ t' with' | 'by using the search and replacement functions in word. In this way, the data in the TXT file is separated by' | ', and you can use sqlload to import data to the database.