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 vote212 views1 answer
How to pass list as parameter in SQL query
SQL
4 votes209 views4 answers
Mysql get date from datetime
SQL
1 vote187 views1 answer
Mysql backup skip table
SQL
3 votes240 views1 answer
Sql select second max
SQL
1 vote186 views1 answer
How to select multiple columns from different tables in mysql
SQL
5 votes204 views3 answers
Show indexes mysql
SQL
5 votes177 views4 answers
Sql check
SQL
0 vote230 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote185 views1 answer
Partitioning in oracle-base
SQL
-1 vote222 views1 answer
Ms sql select datetime as date
SQL