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

1 vote193 views1 answer
OstgreSQL version
SQL
2 votes261 views1 answer
Create mysql user on all hosts
SQL
0 vote219 views1 answer
How to check foreign key constraint in sql
SQL
0 vote186 views1 answer
Postgresql alter column nullable
SQL
0 vote184 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote222 views1 answer
Create table split string function in sql server
SQL
2 votes243 views3 answers
Row number mssql
SQL
1 vote184 views1 answer
Regular expression in sql server
SQL
22 votes253 views4 answers
Date format mysql
SQL
0 vote149 views1 answer
Calculate discount from original price sql
SQL