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

2 votes253 views1 answer
Mysql increment value by 1 in update
SQL
3 votes228 views1 answer
Force using index plsql
SQL
2 votes246 views1 answer
Mysql change data type of column
SQL
1 vote243 views1 answer
Sql how to duplicate a table
SQL
2 votes236 views2 answers
Mysql show table column comments sql
SQL
0 vote253 views1 answer
The package java.sql is not accessible
SQL
0 vote230 views1 answer
Sql inserted
SQL
0 vote251 views1 answer
Sql use with to get value counts and percentages
SQL
4 votes219 views2 answers
How to delete row in sql
SQL
22 votes239 views4 answers
Mysql date format
SQL