교육 예제입니다.

create table address (
street string,
city string,
country varchar(20)
);

create table client (
id string,
name string,
addr address
);

create class department (
dcode char(4),
dname char(10),
clients set client
);

insert into client values(''''AC001'''', ''''홍길동'''', (insert into address values ( ''''테헤란로'''',''''서울'''',''''대한민국'''')) ) ;
insert into client values(''''AC002'''', ''''장길산'''', (insert into address values ( ''''세종로'''',''''서울'''',''''대한민국'''') )) ;

insert into department values(''''D001'''', ''''개발부'''', {}) ;

select client  into :x from client  where id = ''''AC001'''' ;
update department set clients =  clients + { :x }  ;

select client  into :x from client  where id = ''''AC002'''' ;
update department set clients =  clients + { :x }  ;

select * from department
select  dcode, dname, client.id, client.name, client.addr.street  from department, table(clients) as t(client)