Answers for "grab all records from one table to another oracle 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;

Posted by: Guest on August-10-2021

Code answers related to "grab all records from one table to another oracle sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "grab all records from one table to another oracle sql"

Code answers related to "grab all records from one table to another oracle sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "grab all records from one table to another oracle sql"

Code answers related to "grab all records from one table to another oracle sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us