Forum Stats

  • 3,872,914 Users
  • 2,266,489 Discussions
  • 7,911,381 Comments

Discussions

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

User_IAP38
User_IAP38 Member Posts: 47 Green Ribbon
edited Oct 4, 2022 7:56AM in SQL & PL/SQL

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

This discussion has been closed.