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 vote314 views1 answer
Alter table column size oracle
SQL
3 votes474 views9 answers
Linq to sql converter online
SQL
2 votes319 views1 answer
Oracle current date without time
SQL
0 vote315 views1 answer
Original Query
SQL
2 votes320 views1 answer
How to make insert script from table in SQL server
SQL
3 votes317 views1 answer
Oracle apex warn on unsaved changes
SQL
1 vote315 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
1 vote336 views3 answers
Sql procedure
SQL
2 votes348 views1 answer
Q operator in plsql
SQL
4 votes331 views2 answers
Oracle default date format
SQL