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:
Step | Invocation | Result |
---|---|---|
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'.