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 vote139 views1 answer
Oracle query archivemode
SQL
0 vote133 views1 answer
Sql check for null and empty string
SQL
0 vote143 views1 answer
Left join in codeigniter query builder
SQL
0 vote140 views2 answers
Sql having multiple conditions
SQL
0 vote138 views1 answer
Sql server udf performance
SQL
0 vote161 views1 answer
Sql remove non numeric characters
SQL
0 vote134 views1 answer
What are the aggregate function in sql
SQL
0 vote142 views1 answer
Sqlite select split string
SQL
6 votes130 views4 answers
Eloquent to sql with bindings
SQL
0 vote158 views1 answer
Postgresql function ROUND
SQL