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

0 vote142 views1 answer
Postgress append string in select
SQL
0 vote130 views1 answer
Mysql jdbc timezone
SQL
1 vote137 views1 answer
Sql delete all values in a column
SQL
0 vote138 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote139 views1 answer
How to remove identity from a column in sql server
SQL
3 votes162 views1 answer
Apex set debug level
SQL
0 vote130 views1 answer
Create function syntax sql server
SQL
0 vote139 views1 answer
Get primary key of table
SQL
4 votes153 views1 answer
Postgresql create table with index
SQL
0 vote137 views1 answer
Gcloud check sql
SQL