Oracle Database Interview Question:

How To Load Data through External Tables?

Submitted by: Administrator

If you have data stored in external files, you can load it to database through an external table by the steps below:

► Create an external table with columns matching data fields in the external file.
► Create a regular table with the same columns.
► Run an INSERT INTO ... SELECT statement to load data from the external file to the regular table through the external table.

Submitted by: Administrator