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

2 votes224 views1 answer
Oracle run_duration to number
SQL
0 vote295 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote140 views1 answer
Mysql case when null
SQL
0 vote136 views1 answer
Sqlite to csv statement
SQL
1 vote143 views1 answer
Alphabetical order mysql
SQL
0 vote136 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote175 views1 answer
Postgres get database encoding
SQL
0 vote173 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote173 views1 answer
Which lock mode is not available in sql
SQL
0 vote215 views1 answer
How to get number of months between 2 dates sql server
SQL