Oracle insert from select

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

3 votes259 views1 answer
Oracle apex call duration
SQL
0 vote256 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote257 views1 answer
How to make a select in sql
SQL
0 vote270 views2 answers
Postgres show current role
SQL
0 vote267 views1 answer
Mysql date format unix timestamp
SQL
0 vote328 views1 answer
TSQL Find csv file in folder
SQL
5 votes260 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote284 views1 answer
Alter constraint in sql
SQL
7 votes252 views1 answer
Sql management studio display line numbers
SQL
6 votes253 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL