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!

importing excel/csv file into Oracle table

Gor_MahiaOct 23 2022

Hi,
i am looking for a way to import excel file into Oracle (12gR2) table or at least convert the excel into .csv than import into table.
the critical problem ive is that one column is large (CLOB With multiple lines) so sqlloader/external table can't work.
i am looking for virtually any approach maybe Korn shell or java or python etc.
environment is Oracle 12 R2 Enterprise on Unix Solaris
any suggestion please.
thank you.

Comments
Post Details
Added on Oct 23 2022
1 comment
539 views