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 vote133 views1 answer
Sql select min
SQL
2 votes127 views6 answers
In in sql
SQL
0 vote133 views1 answer
Mariadb mysql root access denied
SQL
4 votes122 views2 answers
Mysql how to change default charset
SQL
0 vote144 views2 answers
How to install mssql on mac
SQL
0 vote117 views1 answer
Update if else mysql
SQL
14 votes124 views3 answers
Trim sql
SQL
1 vote143 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote233 views1 answer
How to use select union and loop
SQL
1 vote136 views5 answers
Postgresql difference between two dates in days
SQL