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

3 votes140 views1 answer
APEX elapsed time
SQL
1 vote141 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote147 views1 answer
Left join in codeigniter query builder
SQL
3 votes153 views3 answers
Stop mysql ubuntu
SQL
1 vote140 views1 answer
Group_concat max length mysql
SQL
0 vote138 views2 answers
How to get json data mysql
SQL
-2 votes147 views1 answer
How to open database
SQL
1 vote138 views1 answer
Sql auto date
SQL
0 vote100 views2 answers
Denormalization in sql
SQL
7 votes142 views4 answers
Lowest salary in sql
SQL