/SQL/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;

Source: stackoverflow.com

Similar codes

0 vote275 views1 answer
How to reset table in sql server
SQL
7 votes276 views6 answers
Group_concat in mysql
SQL
7 votes298 views2 answers
Phpmyadmin change password
SQL
0 vote217 views1 answer
Sql count how many times a value appears
SQL
0 vote330 views1 answer
Mysql get nested records
SQL
0 vote282 views1 answer
How to search query in python3 sqlite3
SQL
0 vote303 views1 answer
Get role postgres
SQL
0 vote298 views2 answers
Compound operator in sql
SQL
1 vote272 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote290 views1 answer
Mysql value ends with
SQL