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

5 votes338 views1 answer
Oracle asynchronous update
SQL
0 vote325 views1 answer
Setval postgres example table id
SQL
10 votes297 views2 answers
Django mysql
SQL
2 votes326 views1 answer
Oracle sql day of month from date
SQL
0 vote332 views1 answer
Kill a pid redshift
SQL
6 votes335 views3 answers
Update with inner join postgres
SQL
1 vote339 views2 answers
Drop function in sql
SQL
0 vote407 views1 answer
How to check foreign key constraint in sql
SQL
2 votes336 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
2 votes374 views1 answer
Postgresql group by month and year
SQL