Import Task Example
Suppose the product designers have created a new set of tours on a different system. An import task can be used to import this data (contained in an external set called NEW_TOURS) into the Travel Agency database.
The import SQL statement to import the new data would be:
INSERT INTO tour
FROM new_tours n
The external set elements of which the data type, length, and format would have to be defined are the columns of the Tours table.