Row Types in SQL-3

Row types define types for tuples, and they can be nested.

CREATE ROW TYPE AddressType{

street CHAR(50),

city CHAR(25),

zipcode CHAR(10)

}

CREATE ROW TYPE PersonType{

name CHAR(30),

address AddressType,

phone phoneNumberType

}