create table TT1 (
 rc  varchar2(20),
 usr varchar2(20)
);

create table TT2 (
 rc varchar2(20),
 rst number,
 field varchar2(20),
 def   varchar2(20)
);

create table TT3 (
 rc  varchar2(20),
 class varchar2(20),
 rst number
);

create table TT4 (
 rc varchar2(20),
 email varchar2(80)
);

----------------
insert into TT1 values ('ct1', 'mno');
insert into TT1 values ('pt1', 'pqr');

insert into TT2 values ('ct1',1, 'word', 'read text');
insert into TT2 values ('ct1',2, 'excel', 'write text');
insert into TT2 values ('ct1',3, 'word', 'make text');

insert into TT3 values ('ct1', 1, 'MP');
insert into TT3 values ('ct1', 2, 'SP');
insert into TT3 values ('ct1', 3,'BD');
insert into TT3 values ('ct1', 4,'AB');

insert into TT4 values ('ct1', 'abc@abc.com');