drop table emp_with_double_id

drop sequence my_seq

create table emp_with_double_id 
( 
  id_1 integer, 
  id_2 integer, 
  name varchar2 (50 char) 
)

create sequence my_seq

declare 
  a integer; 
  b integer; 
  c integer; 
  d integer; 
begin 
 
  insert into emp_with_double_id 
    values (my_seq.nextval, my_seq.nextval, 'First Employee'); 
   
  insert into emp_with_double_id 
    values (my_seq.nextval, my_seq.nextval, 'Second Employee'); 
 
  a := my_seq.nextval; 
  b := my_seq.nextval; 
  c := my_seq.nextval; 
  d := my_seq.nextval; 
   
  insert into emp_with_double_id 
    values (a, b, 'Third Employee'); 
     
  insert into emp_with_double_id 
    values (c, d, 'Fourth Employee'); 
     
  commit; 
end; 

select * 
from 
  emp_with_double_id