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

8 votes194 views1 answer
Oracle add auto_increment column to existing table
SQL
6 votes187 views4 answers
How to remove unique key in mysql
SQL
4 votes222 views1 answer
Describe table mysql
SQL
1 vote174 views1 answer
Real world example of nosql
SQL
1 vote189 views1 answer
ORA-01950
SQL
19 votes231 views5 answers
Display table in sql
SQL
2 votes193 views1 answer
Mysql Incorrect column specifier for column
SQL
1 vote199 views3 answers
Drop unique key constraint in sql server
SQL
0 vote193 views1 answer
Sql server set complex constraints
SQL
0 vote206 views1 answer
T sql dynamic top n query
SQL