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

9 votes333 views2 answers
Mysql change value
SQL
0 vote347 views1 answer
Select 1 from orders
SQL
1 vote371 views2 answers
Mysql trim spaces
SQL
2 votes366 views2 answers
Postgres add column integer
SQL
1 vote349 views1 answer
Snowflake rename column name
SQL
1 vote372 views1 answer
Psql view enum values
SQL
2 votes350 views4 answers
Mysql select into new table
SQL
24 votes354 views4 answers
Delete db postgres
SQL
10 votes373 views3 answers
Sql select between two dates
SQL
5 votes311 views1 answer
Mongodb vs
SQL