Oracle insert from select

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 vote282 views1 answer
Is not sql
SQL
18 votes277 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote290 views1 answer
Mysql last 6 months
SQL
2 votes299 views2 answers
Spring import sql
SQL
1 vote277 views1 answer
How do you use sql in you company
SQL
1 vote271 views1 answer
Show table status command in mysql
SQL
0 vote288 views1 answer
Ver usuarios mysql
SQL
1 vote268 views1 answer
Base nosql
SQL
12 votes283 views4 answers
Mysql get date difference in hours
SQL
0 vote271 views1 answer
Postgresql if else endif
SQL