/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 vote205 views1 answer
Oracle character index
SQL
1 vote276 views1 answer
Oracle grant select on schema
SQL
0 vote201 views1 answer
How to declare variable date in mysql
SQL
0 vote223 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote212 views1 answer
Sqlite3 update select
SQL
6 votes199 views2 answers
Mysql get yesterday
SQL
3 votes192 views1 answer
Start mysql server linux terminal
SQL
0 vote216 views1 answer
How to find database collation in postgres
SQL
0 vote220 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote208 views2 answers
Oracle select
SQL