Database Software

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!

How to import data from an excel spreadsheet into a table in Oracle 11g?

Mr. D.W.Jul 13 2021

The performance of an SQL query was degraded significantly after adding an external table to the join clauses. I am investigating the options of avoiding the use of an external table and directly importing the excel spreadsheet data into an oracle table to improve the SQL query performance.
Thanks for your advice.
Regards,
Mr. D.W.

This post has been answered by EdStevens on Jul 14 2021

Jump to Answer

Added on Jul 13 2021

#database-key-features, #export-import-sql-loader-external-tables

5 comments

6,167 views