How to Import data from Excel to Oracle table with SQL Developer

connect to database

expand it and it will display all the object types

 Right click on the object type table


Click on Import data

browse the file and click on open

Click on next

Give the table name that to be created
and click on next

selected columns are the columns that ll appear in the table
click on next

Check all the data types for the columns defaultly it will be varchar2
after confirming all the columns  click on next


Now click on finish




Table with given data is created