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 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote295 views1 answer
Sql runnignsum
SQL
0 vote330 views1 answer
Get create sql of hibernqte entity
SQL
8 votes323 views1 answer
Alter tablespace add datafile autoextend
SQL
10 votes323 views1 answer
Query to find object dependencies in oracle
SQL
0 vote303 views2 answers
Sql query unique
SQL
1 vote336 views1 answer
How to start with sql
SQL
0 vote267 views1 answer
Microsoft sql server management studio clear cache
SQL
2 votes341 views1 answer
Sql string_agg
SQL
32 votes406 views6 answers
Rename column mysql
SQL