
CREATE TABLE lamp_table OF lamp
(PRIMARY KEY product_no)
where lamp_table is the name of a table of type lamp.
A structured UDT can inherit the properties of more than one supertype (this is
known as multiple inheritance, as contrasted with single inheritance). Conflicts may
occur in multiple inheritance. For example, a subtype may inherit different attributes
that happen to have the same name. SQL99 has precise rules governing such situations.
A distinct UDT is a much simpler type than a structured UDT. It is essentially a
renamed version of a built-in data type. For example, suppose goods are sold in UK
currency (pounds, pence) and also in US currency ...