Skip to Main Content

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!

Need to load the excel data to database table on weekly basis automatically

Albert ChaoNov 13 2021
create table LOADER_TAB (
    i_id,
    i_name,
    risk
);

csv file :

portal,,
ex portal,,
,,
i_id,i_name,risk
1,a,aa
2,b,bb
3,c,cc
4,d,dd
5,e,ee
6,f,ff
7,g,gg
8,h,hh
9,i,ii
10,j,jj

I need to load the excel data to a database table on weekly basis. Currently, I am doing using SQL Loader every time. But is there any other way to automate it? I need to load the data every Monday into the table. I am wondering if this can be done with dbms_scheduler? How I will be able to load the data into the table automatically when I load the excel in the folder on weekly basis?

This post has been answered by Satyam Reddy on Nov 14 2021
Jump to Answer
Comments
Post Details
Added on Nov 13 2021
6 comments
946 views