create  table  user_tmp 
(vname varchar(15) , external_pgm varchar(1), eff_date date, exp_date date)

insert 
  into user_tmp 
  values('JOHN','A', '01-JAN-16', '01-APR-16' )

insert 
  into user_tmp 
  values('JOHN','B', '15-FEB-16','01-MAY-16')

  COMMIT