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

2 votes204 views1 answer
Express api ith mysql data
SQL
0 vote203 views1 answer
Query to insert image
SQL
0 vote137 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote169 views1 answer
What is the essence of SQL?
SQL
0 vote183 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote168 views1 answer
Mysql cdn link
SQL
1 vote173 views1 answer
Woocommerce mysql price table
SQL
4 votes217 views2 answers
Postgresql float data type
SQL
8 votes187 views1 answer
How to check mysql version in xampp
SQL
0 vote182 views1 answer
Sql server change schema of a table
SQL