HI Team,
I have this requirement for writing plsql scripts that How to write a pl/sql procedure to transfer data from excel to oracle table?
please share the scripts
in excel sheets have columns and location c:\excel\sales.xls
snbr groupid e_date end_date new_val old_val
1234 A23456 2022-02-01 2022-02-01 10 5
1234 A23457 2022-02-01 2022-02-01 5 20
1234 A23458 2022-02-01 2022-02-01 100 50
Table Structure
create table sales_upd (snbr number(38,0),groupid VARCHAR2(50), e_date date, end_date date , new_val number(38,0), old_val number(38,0))
Thanks