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 vote145 views1 answer
Mysql locate
SQL
0 vote142 views1 answer
Sql server datetime to string
SQL
4 votes134 views1 answer
Check database name postgresql
SQL
0 vote156 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote151 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote169 views1 answer
Oracle current date minus 1 day
SQL
1 vote135 views1 answer
Sql only five first row
SQL
0 vote159 views1 answer
Least spark sql
SQL
0 vote139 views1 answer
Mysql uuid
SQL
1 vote153 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL