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 vote133 views1 answer
Mysql procedure between two tables
SQL
9 votes139 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote123 views1 answer
Mysql isshow
SQL
4 votes127 views2 answers
Mysql select where starts with
SQL
0 vote120 views1 answer
Convert rows to columns in sql server
SQL
0 vote140 views1 answer
WHERE not regex in SQL
SQL
17 votes134 views6 answers
Change column name in sql
SQL
0 vote112 views1 answer
Login phpmyadmin without password
SQL
1 vote157 views1 answer
Insert column after column mysql
SQL
4 votes153 views4 answers
Remove duplicate old value in mysql
SQL