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 vote140 views1 answer
Drop all tables in azure sql database
SQL
0 vote154 views1 answer
Typeorm raw sql
SQL
0 vote162 views1 answer
Get record which is available in one table but not in another mysql
SQL
1 vote162 views1 answer
Select users with same username
SQL
0 vote163 views1 answer
Get who is hired in february in sql
SQL
0 vote202 views1 answer
Dockerfile example for Django
SQL
27 votes159 views5 answers
Add column in table
SQL
1 vote187 views3 answers
How to create a table structure from another table in mysql
SQL
3 votes168 views1 answer
Postgres update column with value from another table
SQL
48 votes250 views3 answers
Psql create database
SQL