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 vote289 views1 answer
Sql delete dastabase
SQL
2 votes631 views1 answer
Oracle virtual column
SQL
0 vote303 views1 answer
Database xml sql
SQL
4 votes308 views2 answers
Installing sql on ubuntu
SQL
0 vote280 views1 answer
How to connect to mysql in ef 6
SQL
1 vote293 views1 answer
Oracle finding duplicate records
SQL
0 vote296 views1 answer
Sqlite to csv statement
SQL
0 vote308 views2 answers
Sql count number of rows after group by
SQL
1 vote313 views1 answer
Mysql breakline on string
SQL
0 vote302 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL