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 vote268 views1 answer
Order by in codeigniter query builder
SQL
1 vote269 views1 answer
Pgsql sum switch case
SQL
3 votes274 views2 answers
Install mysql powershell
SQL
1 vote262 views1 answer
Mysql query where in select
SQL
1 vote242 views1 answer
Postgresql convert text to float
SQL
2 votes223 views1 answer
Sql select in list
SQL
1 vote240 views2 answers
Mysql SELECT
SQL
0 vote250 views2 answers
Sqlite
SQL
21 votes255 views6 answers
Docker run mysql
SQL
-1 vote267 views1 answer
Mac mysql workbench console
SQL