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 vote138 views1 answer
Importance of comment in mysql
SQL
14 votes159 views6 answers
Auto_increment mysql
SQL
1 vote150 views1 answer
Sqlite check if row exists
SQL
2 votes185 views1 answer
Search query in mysql
SQL
0 vote199 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
11 votes151 views2 answers
Oracle source code
SQL
20 votes168 views5 answers
Reset auto increment mysql
SQL
0 vote185 views1 answer
Get initials name in sql
SQL
1 vote170 views1 answer
Sql first day quarter
SQL
1 vote157 views1 answer
Count mysql server db tables
SQL