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 vote217 views1 answer
Count database access django
SQL
0 vote222 views1 answer
"Hello User Name"
SQL
1 vote191 views1 answer
Type int in mysql maxlenght
SQL
1 vote204 views1 answer
Oracle sql average
SQL
3 votes201 views1 answer
Oracle sql commit example
SQL
9 votes229 views2 answers
SELECT User,Host FROM mysql.user;
SQL
2 votes184 views3 answers
3 days back in sql server
SQL
2 votes188 views1 answer
Tsql copy table
SQL
0 vote207 views1 answer
Hex string sql becomes int64
SQL
-2 votes209 views1 answer
Trunc in sql
SQL