Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Load Data through External Tables?
Answer:
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.
► 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.
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
What Is an External Table? | What Are the Restrictions on External Table Columns? |