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 vote299 views1 answer
Oracle query to see what scema i am working in
SQL
4 votes294 views1 answer
SQL order random
SQL
1 vote308 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote329 views1 answer
Size of all tables in a schema oracle
SQL
2 votes329 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote332 views1 answer
SQL query to get all table records count from a database
SQL
2 votes318 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote300 views1 answer
Mysql command prompt date insert format
SQL
0 vote315 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote327 views1 answer
Adding primery key constraint to a column
SQL