Script for retrieving datas -Oracle -
I need to write scripts to capture Excel data in the database table. The table name is B_USER
then .. choose from ..? Any help would be appreciated
INSERT in B_USER
(SELECT U_ID,
U_NUMBER - FROM ????)
SQL loader is an Oracle utility that can be used to load data files in database tables. But I do not think this supports the Excel file. Please convert the Excel file into CSV or any other delimited format, then use the SQL loader. Please know about this.
Comments
Post a Comment