Import Task Example

See Also

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

(

       destination

,        tour_type

,        num_days

,        max_age

,        description

,        image1

)

SELECT

       n.destination

,        n.tour_type

,        n.num_days

,        n.max_age

,        n.description

,        n.image1

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.