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 read an Excel file and dump the data into a table without using External Table or SQL Loader

LazarNov 7 2019 — edited Nov 8 2019

Hi All/@Marwim,

I'm having a requirement to read an Excel file(xlsx/xls) from my local machine and to dump the data into a table(BLOB/CLOB).

But i dont have access to use External Table or SQL Loader concepts. So i put into a state where to use the oracle PLSQL concepts alone.

Also i have gone through Anton Scheffer package, which has been coded to read the excel files from the UNIX/LINUX server and not from the local machine.

Could someone help me out on this with the simple sample codes to perform it with oracle PLSQL logic ?

Oracle DB Version : 12C

Regards,

Lazar

Added on Nov 7 2019

7 comments

901 views