Insert Data Oracle From Select

Creamos la tabla

CREATE TABLE CONTACTS
("FIRST_NAME" VARCHAR2(30), "LAST_NAME" VARCHAR2(30));

Y la poblamos con el contenido parcial de otra…

INSERT INTO CONTACTS (FIRST_NAME,LAST_NAME)
SELECT FIRST_NAME,LAST_NAME 
from employees;