Question: how to import data from excel in pl sql developer?
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.