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 vote200 views1 answer
Create tables from xsd to sql server database c#
SQL
1 vote193 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote240 views2 answers
Sql unique
SQL
1 vote190 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote150 views1 answer
Sqlalchemy existing database
SQL
0 vote188 views1 answer
How to check which sp is running in sql server
SQL
2 votes194 views1 answer
Get first 2 letter in sql
SQL
0 vote195 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote200 views1 answer
Get schema of table sql
SQL
0 vote192 views1 answer
Alter table add foreign key mariadb example
SQL