create or replace type typou as object
( 
 id number,
 str varchar2(30),
 constructor function typou return self as result 
) 
/

create or replace type body typou as 

constructor function typou return self as result as
begin
    return;
end;
end;
/

create or replace type typou#varray as varray(10) of typou
/

drop table typou_table
/

create table typou_table (
id number,
typou_varray typou#varray 
)
/

insert into typou_table 
values (1, typou#varray(typou(1,'odin'),typou(2,'two')))
/

insert into typou_table 
values (2, typou#varray(typou(2,'two'),typou(1,'odin')))
/

insert into typou_table 
values (3, typou#varray(typou(1,'adin'),typou(2,'two')))
/

select *
from typou_table t1, 
     typou_table t2
where (select t11.id||t11.str from table(t1.typou_varray) t11 minus select t22.id||t22.str from table(t2.typou_varray) t22) is null
      and t1.id != t2.id
/