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 vote200 views1 answer
Temp table vs variable table in sql server
SQL
3 votes195 views2 answers
Having in mysql
SQL
0 vote216 views2 answers
MySQL PARTITION BY month automatically
SQL
1 vote212 views1 answer
Sql avg group by
SQL
1 vote227 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote180 views1 answer
Ms sql unique
SQL
1 vote212 views1 answer
SQL query to get all table records count from a database
SQL
2 votes210 views1 answer
Sql column values comma separated
SQL
0 vote202 views1 answer
Pgadmin see indexes
SQL
2 votes212 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL