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

1 vote158 views1 answer
Sql avg group by
SQL
8 votes218 views1 answer
Mysql dump restore
SQL
2 votes168 views1 answer
Compare date in sql
SQL
7 votes164 views4 answers
Lowest salary in sql
SQL
7 votes157 views6 answers
Group_concat mysql
SQL
1 vote160 views1 answer
What is int in mysql
SQL
2 votes171 views3 answers
How to check current user in mySQL
SQL
1 vote234 views1 answer
Base64 encode sql server
SQL
35 votes181 views6 answers
Postgres
SQL
0 vote176 views1 answer
Mysql query with sql to get the next row
SQL