CODEWITHSUNDEEP
oracle-database
abc
abc

Reputation: 45

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 appreciated

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

Upvotes: 0

Views: 72

Answers (1)

Sujee
Sujee

Reputation: 5145

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.

Upvotes: 4

Related Questions