Oracle insert into where

INSERT INTO my_table SELECT * FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
	WHERE s.my_col >= 10;

Similar codes

0 vote312 views1 answer
Grant owner postgresql
SQL
0 vote324 views1 answer
How to check if there is no database schema
SQL
0 vote356 views1 answer
Shrink database file in sql server
SQL
0 vote347 views1 answer
Sql server select record with max id
SQL
0 vote395 views1 answer
Postgresql alter table sequence
SQL
1 vote320 views1 answer
Delete mysql from mac
SQL
0 vote354 views1 answer
Sql gather statistics to increase performance
SQL
1 vote347 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote340 views1 answer
Db format in quotation
SQL
0 vote345 views1 answer
Sql server list table sizes
SQL