Script for retrieving datas -Oracle

Question

Hi

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 appreciated

INSERT INTO B_USER
(SELECT U_ID,
U_NUMBER
FROM ???? )

Answer 1

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.