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 vote207 views1 answer
Sqlserver create table from select
SQL
0 vote311 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote218 views1 answer
Excel vba import data to sql server
SQL
19 votes194 views2 answers
Mysql tinyint max value
SQL
1 vote203 views1 answer
How to set up a trigger in sql
SQL
0 vote199 views1 answer
Mysql add to number
SQL
3 votes190 views4 answers
Ubuntu stop mysql
SQL
0 vote192 views1 answer
Sql get date from timestamp
SQL
2 votes203 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote223 views1 answer
Select all same column value in sql
SQL