1.

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.

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


Discussion

No Comment Found

Related InterviewSolutions