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)
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)