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

5 votes177 views2 answers
Sql constraint check value in list
SQL
2 votes169 views1 answer
Sql missing records from another table
SQL
10 votes158 views1 answer
How to import database in mysql by cmd
SQL
0 vote209 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
2 votes184 views1 answer
Oracle sql merge
SQL
1 vote173 views2 answers
Sql drop multiple columns if exists
SQL
0 vote137 views1 answer
Mysql sleep connections
SQL
11 votes190 views5 answers
Sql server reset identity
SQL
0 vote171 views1 answer
Database get 10 user aleatory
SQL
11 votes179 views4 answers
Update row in mysql
SQL