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

1 vote184 views1 answer
Mysql get domain from url
SQL
7 votes308 views2 answers
Mysql default value
SQL
6 votes220 views2 answers
Insert into select mysql
SQL
0 vote227 views3 answers
Java hide mysql login credentials
SQL
1 vote189 views1 answer
Give a column name to values generated from case statement in sql
SQL
1 vote216 views1 answer
Postgres power
SQL
0 vote200 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote188 views1 answer
Sql padd let with zeros
SQL
2 votes179 views1 answer
Rails execute sql
SQL
2 votes160 views1 answer
Oracle current date without time
SQL