How to Import Excel sheet data into Oracle table using SQL Developer

1. create table

create table emp1
(
First_name varchar2(30),
Last_name varchar2(30),
dept_no number,
salary number,
emp_id number);

2. Now goto connections>Tables>EMP1

Filter table name in which you need to insert the data from excel sheet as shown below.

3. select the table and right click and select "import data" as shown below

 

4. Right side you will get the below window

 

click on browse and select our excel sheet which contains the data

 

click open and data will be shown

 

Now click on Next button

 

Import Method should be Insert

and then again click Next button

 

 Again click Next button

 

Click on Next Button

 

Click on Finish button

 

It will give the message that data is inserted successfully into table.

Now click Ok and then query the table as shown below