Oracle's fast way to import Excel data uses the Plsql Developer tool, which is the most common tool used by Oracle's most famous DBA.
In cases where a single file is small (less than 100000 lines), and the destination table structure already exists-certainly not for Excel, because the maximum behavior of the Excel file 65536--can be copied all the time, then use the Plsql Developer tool.
1 in Plsql Developer SQL window, enter SELECT * from test for update;
2 Press F8 to execute
3 Open the Lock, and then click the plus sign. Mouse points to the column header of the first column, so that the whole column is selected, and then pasted, the last commit can be committed.
(1) If it is a single-column data import, you can first press Plsql developer the "Add (+)" button above the query results, so that the data table in the Add data state, and then the mouse on the Plsql developer column name, and finally use the shortcut key Ctrl + V Complete the data import operation and click the Submit (Checkmark) button in Plsql Developer to submit your changes.
(2) If you are importing all the columns at the same time, first select Copy all data, then click Add (+) and tap edit the first asterisk in the line to make the entire row of data is selected, and finally paste to import the data.
(3) If you want to import data in columns, you need to complete each column, first select the data you want to import, then click Add (+) to edit the name of the column so that the entire column of data is selected, and finally paste to import the data.
Oracle Import Excel Data fast method