INSERT INTO mens values (Mensagem('oi','aeeeeeeeeeee')); insert into table(select u.mens from Usuarios u where u.login like 'laon') Values((select ref(m) from mens m where m.titulo = 'oi')); insert into Usuarios values (Usuario('Beto','laon', '111',posMens_nested(),posComp_nested(), posAmigo_nested(), posProf_nested(), posfam_nested())); select l.ref_disc.nome,c.nome,l.qtde from curso c, the(select lista_membro from curso c1 where c1.num_curso = c.num_curso) l where l.ref_al.Mat = 2; select m.ref_mens.descricao from Usuarios u, the(select mens from Usuarios u1 where u1.login like 'laon') m where m.ref_mens.titulo like 'oi'; select m.ref_mens.descricao from Usuarios u, the(select mens from Usuarios u1 where u1.login like 'lino') m;