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 vote114 views1 answer
Update top 100 sql
SQL
6 votes98 views1 answer
Oracle rank() over (partition)
SQL
2 votes160 views1 answer
Orcale index size
SQL
1 vote122 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote163 views1 answer
Regex mongoose
SQL
4 votes117 views1 answer
Postgres delete last row
SQL
2 votes114 views1 answer
Mysql sysdate
SQL
0 vote267 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote113 views1 answer
Postgresql stored procedure update table values
SQL
0 vote149 views1 answer
Postgres foreign key multiple columns
SQL