<employee>
<row>
<givenname>Roy</givenname>
<familyname>Connor</familyname>
<address>
<address1>123 First Street</address1>
<city>Denver</city>
<state/>CO</state>
<zipcode>80111</zipcode>
</address>
<phone>303-555-1212</phone>
</row>
</employee>

create row type address_t(
city varchar( 20 ),
zip char( 6 )
);
create table ab(
fio varchar( 20 ),
address address_t,
phone varchar( 10 )
);
insert into ab values('P.Dmitriev',row('Moscow','123321')::address_t,'7766554');

<ab>
<row>
<fio>P.Dmitriev</fio>
<ROW>
<city>Moscow</city>
<zip>123321</zip>
</ROW>
<phone>7766554</phone>
</row>
</ab>

create table ab (
   fio char( 10 ),
   address multiset(row(city char( 20 ),zip char( 6 )) not null),
   phone char( 10 )
);

insert into ab values('P.Dmitriev',"multiset{ROW('Citi1','zipzip')}",'7766554');

select genxmlelem(ab,'ab') from ab;

<ab>
   <row>
      <fio>P.Dmitriev</fio>
      <address>
         <city>Citi1               </city>
         <zip>zipzip</zip>
      </address>
      <phone> 7766554    </phone>
   </row>
</ab>