Oracle insert

http://psoug.org/reference/insert.html

INSERT SELECT

INSERT INTO table1
SELECT col1, col2, col3
FROM table2 where col1 ='a';

SELECT * FROM table1;