SQL

grab all records from one table to another oracle sql

--tbl_temp1 is the source
--tbl_temp2 is the destination
--fld_id is the columns you want to bring over
--where statement is up to you!

INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;