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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

mNem
Answer

did you try right-click on the project name from Projects panel and Copy ... option?

Marked as Answer by OTG-467455 · Sep 27 2020
1 person found this helpful
mNem

If I were you, for "exploring different scenarios", I would just stick with creating a new class (copy the existing one if you like) and make modifications all in the same project (instead of cloning the entire project).

HTH.

1 person found this helpful
OTG-467455

Hi mNem,  Both of your suggestions are good.  I just wanted to create a replica, mess around and then drop it.  So the clone works just right for me.  Thanks for your quick thinking.

1 - 3
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,526 views