Structured Types(cont.) User-defined row types create type PersonType as( name Name, address Address, dateOfBirth date) not final Can then create a table whose rows are a user-defined type create table customer of CustomerType Alternative using unnamed row types. create table person_r( name row(firstname varchar(20), lastname varchar(20)) address row(street varchar(20), city varchar(20), zipcode varchar(20)), dateOfBirth date) Database System Concepts-6th Edition 22.9 ©Silberschat乜，Korth and SudarshanDatabase System Concepts - 6 22.9 ©Silberschatz, Korth and Sudarshan th Edition Structured Types (cont.) User-defined row types create type PersonType as ( name Name, address Address, dateOfBirth date) not final Can then create a table whose rows are a user-defined type create table customer of CustomerType Alternative using unnamed row types. create table person_r( name row(firstname varchar(20), lastname varchar(20)), address row(street varchar(20), city varchar(20), zipcode varchar(20)), dateOfBirth date)