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 vote250 views1 answer
Testing sql queries
SQL
-1 vote323 views1 answer
Utf8_encode mysql
SQL
-1 vote297 views1 answer
Mysql extract days
SQL
0 vote347 views2 answers
Check if sql temp table exists
SQL
0 vote305 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote302 views1 answer
Oracle create index if not exists
SQL
4 votes315 views2 answers
REST API
SQL
0 vote327 views1 answer
Migration graphql
SQL
0 vote325 views1 answer
The package java.sql is not accessible
SQL
0 vote337 views1 answer
T-sql delete view if exists
SQL