Oracle insert into where

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 vote192 views1 answer
Mysql find db contarint
SQL
2 votes206 views1 answer
Mysql time ago difference
SQL
0 vote191 views1 answer
How to get n result in sql
SQL
0 vote228 views1 answer
Delete a temporary table mysql
SQL
6 votes236 views2 answers
Insert into select mysql
SQL
1 vote201 views1 answer
Mysql show queries running
SQL
0 vote207 views1 answer
Sqlite insert or update
SQL
0 vote187 views1 answer
Mysql sql select one day before
SQL
2 votes214 views1 answer
Mysql cannot delete or update a parent row
SQL
11 votes230 views5 answers
Laravel db facade
SQL