Question: how to import data from excel to oracle table using pl sql?
Answer: Step 0: The Empty Oracle Table and your Excel File. ...  Step 1: Mouse-right click – Import Data. Step 2: Select your input (XLSX) file and verify the data. ...  Step 3: Create a script or import automatically. ...  Step 4: Select the Excel Columns to be Imported. ...  Step 5: Map the Excel Columns to the Table Columns.