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

9 votes336 views1 answer
Sql server get utc date
SQL
1 vote327 views1 answer
Stop mysql server mac
SQL
6 votes333 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
4 votes352 views1 answer
Id increment ms sql server
SQL
0 vote374 views1 answer
SQL server datetime compare
SQL
0 vote367 views1 answer
Querry mysql by 2 columns
SQL
15 votes327 views4 answers
Pl sql
SQL
1 vote286 views1 answer
Postgres reset auto increment
SQL
2 votes338 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote337 views1 answer
Set open file limit mac catalina mysql
SQL