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

3 votes140 views2 answers
Sql random integer
SQL
0 vote181 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote141 views1 answer
Oracle enable chain
SQL
0 vote144 views1 answer
Sql select where more than one record exists
SQL
0 vote135 views1 answer
Run postgresql dump to csv
SQL
0 vote131 views1 answer
Postgresql find missing id
SQL
1 vote145 views1 answer
Does insert into overwrite sql
SQL
0 vote130 views2 answers
Soql last year
SQL
7 votes149 views6 answers
Group_concat in mysql
SQL
0 vote150 views1 answer
Check the size of the tables here ordered from the biggest size
SQL