create type tsuns (
vards varchar2(20)
);
create type tsaimnieks (
vards varchar2(20),
suns ref tsuns
);
create table sunji of tsuns;
create table saimnieki of tsaimnieks;
insert into sunji tsuns('Reksis');

load data
infile *
into table saimnieki
fields terminated by whitespace (
vards char,
suns ref(constant 'sunji', suns_),
suns_ filler char
)
begindata
Jānis Reksis