Use the INSERT INTO clause to specify the table, synonym, or view in which to load the new data.

You must specify the column names only if one of the following conditions is true:
  • You are not loading data into all columns.
  • The input file does not match the default order of the columns (the order specified when the table was created).

The INTO clause cannot specify a table object that the CREATE EXTERNAL TABLE statement defined.

The following example identifies the price and discount columns as the only columns in which to add data. The example uses Windows™ file naming conventions.
LOAD FROM 'C:\tmp\prices' DELIMITER ','
   INSERT INTO norman.worktab(price,discount)