The following statement creates a table that defines an address column named location:
CREATE TABLE italian_sales (location address ,sales DECIMAL(8,2));
The location column reference in the following statement returns an address UDT expression.
INSERT INTO italian_sales SELECT location, sales FROM european_sales WHERE region = 1151;