Script for retrieving datas -Oracle

I need to write script to capture the excel datas to a database table.Table name is B_USER

So select * from ..? Any help will be apprec开发者_如何学Goiated

INSERT INTO B_USER

(SELECT U_ID,

U_NUMBER

FROM ???? )

SQL Loader is an Oracle utility which can be used to load data files into database tables. But I don't think it supports excel file. Please convert the excel file into CSV or any other delimited format, then use SQL loader. Please learn about it in the SQL loader documentation.