How can we insert data of an excel sheet to an Oracle database?

Use sql developer to import the data.. Steps to be followed

Step1: Selecting tale and right click then select import option

Step2:Select the file

Step3:Check all options and changed the options based on your requirement

Step4:Choose the method and Import the data

Step5:Check the columns definition

Verify the data

you can use MS Access and import that excel to ms access and connect ms access to oracle with ODBC and make append querty to add data to the oracle table.

and you can use other3rd party software.

We Use APEX Oracle Aplication express to import  data from EXCEL CSV file or try other tools

An other Option is toad(toad for oracle).Through toad u can insert data from Excel to Database without any manual handling. In toad menu path is Database---Import---import table data

 after selecting this option wizard run and gave the object name means table, in which table u want to inserting data from excel, then select Excel option and browse the excel file and see next options.......

Data insert with verification and u also see on screen.Can,t doubt any Error/Problem.

Rana Imran

You create a data source link it to excel.. you create a hetrogeneous datasource inside oracle to read directly from excel sheets.

you will fire queries like select * from sheel1$@dblink name it will fetch data into oracle.

just search on web for exact steps to read excel data into oracle using hetrogeneous services...

we can insert data through sql loader.

you can use "data loader program " if number of record under500 if number of record is more than500 you should use toad 

we can use oracle SQLloader utility

the  solution by Rana is a good one if you are working in the back end and you want to fill data in tables.but if you want to work on the front end, i mean on oracle forms you have to create a button and in when bottom pressed you have to write a kind of procedure to read from the excel file. It seams complicated because you have to get a specific code for excel so you can read from oracle the content of excel sheet.also pay attention on the dimension in the excel file.try to make some search on net.it's feasible.

You might use oracle data loader to move data. 

http://www.oracleport.com/using-data-loader/

Save the Excel file as CSV. and then use Oracle SQL Loader utility on that CSV file to load it to a table.