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

5 votes190 views3 answers
String concatenation sql server
SQL
0 vote175 views2 answers
How to count codition
SQL
1 vote167 views1 answer
Drush sql-dump
SQL
0 vote182 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote166 views1 answer
Json_remove mysql
SQL
1 vote172 views1 answer
Mamp mysql path mac
SQL
0 vote177 views1 answer
Object of class mysqli_result could not be converted to string
SQL
4 votes162 views2 answers
Truncate oracle
SQL
-1 vote231 views1 answer
MYSQL stored procedure select from
SQL
0 vote187 views1 answer
Select into table variable
SQL