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
Aug 29 2019

Artur M

Very often, we face the problem of how to import data from files to the database. PL/SQL provides an interesting solution: external tables. In this video, we will learn all about external tables.