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 vote228 views1 answer
What is logical database schema
SQL
23 votes217 views3 answers
Mysqldump
SQL
0 vote229 views1 answer
Template MySQL Zabbix agent
SQL
1 vote223 views1 answer
Xampp import sql file command line
SQL
1 vote243 views1 answer
SQL query to get all table records count from a database
SQL
0 vote239 views1 answer
Sql get date from timestamp
SQL
0 vote253 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote267 views1 answer
How to check rollback status in oracle
SQL
0 vote249 views2 answers
How to count codition
SQL
3 votes231 views1 answer
Kill mysql processlist in whose time more than 200
SQL