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 vote350 views1 answer
Postgres declare variable
SQL
0 vote364 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote372 views1 answer
Cast float mysql
SQL
0 vote356 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote363 views1 answer
Convert rows to columns in sql server
SQL
2 votes346 views1 answer
Alter table add multiple columns postgresql
SQL
3 votes374 views2 answers
Postgres alter table owner
SQL
1 vote356 views1 answer
Mysql select if empty result
SQL
10 votes334 views2 answers
Mysql select timestamp group by day
SQL
0 vote345 views1 answer
Sql cross apply vs join
SQL