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 vote273 views6 answers
Unique key in sql
SQL
1 vote298 views1 answer
Find a column in all tables postgres
SQL
1 vote293 views7 answers
Filter
SQL
0 vote279 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote276 views1 answer
Return size of tables in mysql
SQL
2 votes609 views1 answer
Oracle virtual column
SQL
-1 vote278 views1 answer
How to check table exists or not in postgresql
SQL
1 vote298 views1 answer
Postgres set column based on another column
SQL
0 vote306 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote293 views1 answer
Mysql 5.6 hierarchical recursive query
SQL