create table emp2(
emp_id  number(10) not null,
emp_name    varchar2(50),
CONSTRAINT pk_emp_ID PRIMARY KEY (emp_id)

);

create table dept2(
dept_id number(10) not null,
dept_seq_no     number(10),
col_type        varchar2(50),
emp_id number(10),
CONSTRAINT fk_emp_id FOREIGN KEY (emp_Id)
REFERENCES emp2(emp_Id));

insert into dept2
values(10,1,'UPDATE',100);

insert into dept2
values(20,2,'WHERE',100);

insert into dept2
values(30,3,'WHERE',100);

insert into dept2
values(40,1,'UPDATE',101);

insert into dept2
values(50,2,'WHERE',101);

insert into dept2
values(60,3,'WHERE',101);

insert into dept2
values(70,1,'UPDATE',102);

insert into dept2
values(80,2,'WHERE',102);

insert into dept2
values(90,3,'WHERE',102);

insert into dept2
values(100,1,'UPDATE',103);

insert into dept2
values(110,2,'WHERE',103);

insert into dept2
values(120,3,'WHERE',103);



insert into emp2
values(100, 'John');

insert into emp2
values(101, 'Joe');

insert into emp2
values(102, 'Josh');

insert into emp2
values(103, 'Aaron');

insert into emp2
values(104, 'Jay');

insert into emp2
values(105, 'Sam');

insert into emp2
values(106, 'Tom');

insert into emp2
values(107, 'Brett');

insert into emp2
values(108, 'Colin');

insert into emp2
values(109, 'Steve');