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 vote215 views1 answer
Mysql get date diff in months
SQL
2 votes200 views3 answers
Mysql pass command from command line
SQL
0 vote211 views1 answer
Procedures sql insert mysql
SQL
1 vote203 views1 answer
List all triggers in SQL Server
SQL
0 vote287 views1 answer
Last date for each user sql
SQL
0 vote244 views1 answer
Mysql show schema
SQL
0 vote204 views1 answer
Flush user resource mysql
SQL
0 vote197 views1 answer
Oracle free up space in tablespace
SQL
11 votes209 views3 answers
Sql_mode=only_full_group_by
SQL
45 votes288 views5 answers
Grant all privileges mysql
SQL