Miscellany
public text v1 · immutableINSERT 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);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);