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 vote124 views2 answers
Plsql function that return a table
SQL
8 votes127 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote82 views1 answer
Mariadb list tables
SQL
1 vote129 views1 answer
Add sequence postgres
SQL
0 vote120 views1 answer
Supprimer les valeur d'une table mysql
SQL
3 votes118 views2 answers
Create schema postgres
SQL
0 vote136 views1 answer
How to combine rows in sql server procedure
SQL
0 vote121 views1 answer
Get record which is available in one table but not in another mysql
SQL
3 votes120 views2 answers
Truncate all tables
SQL
0 vote109 views1 answer
Postgres set default schema
SQL