Declare variables for column data with the LIKE clause

If you use the LIKE clause, the database server defines a variable to have the same data type as a column in a table or view.

If the column contains a collection, row type, or nested complex type, the variable has the complex or nested complex type defined in the column.

In the following figure, the variable loc1 defines the data type for the locations column in the image table.
Figure 1: Define the loc1 data type for the locations column in the image table.
DEFINE loc1 LIKE image.locations;