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.
 

PL/SQL - Fast Import Data Into A Database