Answers for "how to get all the records from 2 tables in oracle"

SQL
1

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;
Posted by: Guest on August-10-2021

Code answers related to "how to get all the records from 2 tables in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language