Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

selvi mFeb 1 2022 — edited Oct 4 2022

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 1 2022
Added on Feb 1 2022
#excel, #plsql, #sql, #sqldeveloper
8 comments
4,595 views