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

7 votes264 views3 answers
How to check table name in current database sql
SQL
0 vote280 views1 answer
Connexion mysql
SQL
1 vote289 views2 answers
Find nth highest salary of an employee
SQL
25 votes295 views3 answers
How to use a database to see tables mysql
SQL
0 vote377 views2 answers
Sqlalchemy default value for column
SQL
0 vote288 views1 answer
Database traccar
SQL
0 vote270 views1 answer
Sql find table by name
SQL
0 vote306 views1 answer
Sql server for loop
SQL
4 votes278 views1 answer
Oracle select first 10 rows
SQL
4 votes286 views3 answers
Is not null sql
SQL