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 vote212 views1 answer
Oracle drop temporary table
SQL
2 votes179 views1 answer
Oracle kill job by sid
SQL
1 vote183 views3 answers
Get all tables postgres
SQL
0 vote177 views1 answer
Sqlite3 pragma foreign keys
SQL
5 votes170 views1 answer
How to use rank function in sql
SQL
0 vote180 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
3 votes165 views2 answers
Having in mysql
SQL
0 vote164 views2 answers
Show slave status mysql
SQL
1 vote164 views1 answer
Search for tables with name postgresql
SQL
0 vote182 views1 answer
Mysql value ends with
SQL