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

-1 vote295 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote293 views1 answer
Sql missing values
SQL
1 vote283 views1 answer
Oracle insert multiple rows into same table
SQL
3 votes263 views3 answers
Docker create postgresql database
SQL
0 vote265 views1 answer
Mysql terminal list table
SQL
0 vote265 views1 answer
How to get employee having maximum experience in mysql
SQL
10 votes263 views4 answers
Mysql one week ago
SQL
0 vote330 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote266 views1 answer
Sql case when exists in another table
SQL
11 votes267 views2 answers
Set default column value sql
SQL