INSERT INTO  sales_reps (id, name, salary, commission_pct)

 SELECT employee_id, last_name, salary, commission_pct

FROM employees

WHERE  job_id LIKE   ‘%REP%’;

Subinterogarea se poate utiliza  în locul unui nume de tabel în clauza INTO a  comenzii INSERT:
 

INSERT INTO

    (SELECT employee_id, last_name, email, hire_date, job_id, salary,department_id

        FROM employees)

VALUES (99999, ‘David’, ‘edavid’, TO_DATE (‘07-Jun-99’, ‘DD-MON-RR’),‘ST_CLERK’, 7000,50);