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!INSERTINTO tbl_temp2 (fld_id)SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id >100;