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 vote127 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote136 views1 answer
Primary key start from number
SQL
0 vote119 views1 answer
Mysql grant user wildcard database
SQL
1 vote111 views1 answer
Oracle apex run 404
SQL
0 vote118 views2 answers
Csv into data postgres
SQL
1 vote147 views1 answer
Mysql view curren querys
SQL
0 vote117 views1 answer
When mysql server would not work in xampp
SQL
1 vote115 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote110 views1 answer
Change schema of all tables postgres
SQL
0 vote124 views1 answer
How to export only procedures mysql
SQL