INSERT INTO (SELECT emp_no, ename, hiredate, job, sal, dept_no FROM e2 WHERE dept_no = 20) VALUES (999, 'DTAYLOR', '07-JUN-99', 'ST_CLERK', 5000, 20);