The following statement uses the built-in constructor function and mutator methods to return a new instance of the address UDT and insert it into the european_sales table:
INSERT INTO european_sales VALUES (101, address().street('210 Stanton').zip('76543'), 500);
Teradata Database executes the UDT expression in the following order:
|1||address() constructor function||Default UDT instance|
|2||mutator method for street||UDT instance with street attribute set to '210 Stanton'|
|3||mutator method for zip||UDT instance with zip attribute set to '76543'|
The final result of the UDT expression is an instance of the address UDT with the street attribute set to '210 Stanton' and the zip attribute set to '76543'.