accept e_fname prompt 'Enter first name: '
accept e_minit prompt 'Enter middle initial if any: '
accept e_lname prompt 'Enter last name: '
accept e_ssn prompt 'Enter ssn: '
accept e_bdate prompt 'Enter birthdate in (MM-DD-YYYY) format: '
accept e_address prompt 'Enter address: '
accept e_sex prompt 'Enter sex: '
accept e_salary prompt 'Enter salary: '
accept e_superssn prompt 'Enter supervisor''s ssn: '
accept e_dno prompt 'Enter department number: '

insert into department values ('&e_fname', '&e_minit', '&e_lname', '&e_ssn', TO_DATE('&e_bdate','MM-DD-YYYY'), '&e_address', '&e_sex', &e_salary, '&e_superssn', &e_dno);



