Forum Stats

  • 3,837,615 Users
  • 2,262,274 Discussions
  • 7,900,331 Comments

Discussions

Write a pl/sql procedure to transfer data from excel to oracle table

User_IAP38
User_IAP38 Member Posts: 15 Green Ribbon

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

Answers