PL/SQL - Fast Import Data Into A Databas...

External tables

The external tables feature is a complement to existing SQL*Loader functionality. It enables you to access data in external sources as if it were in a table in the database, and that's the power of the solution. You can run SELECT statements on the data in the file as if they were data in a table.
In this video tutorial, we will get the introduction to External Tables and how they can be used to import the data faster in a database.