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 vote137 views1 answer
Insert array into mysql column
SQL
33 votes125 views2 answers
Postgres how to add field created at
SQL
9 votes139 views2 answers
Sql limit order by
SQL
0 vote128 views1 answer
Update set with inner join oracle
SQL
0 vote173 views1 answer
Wordpress make wp user in db
SQL
0 vote145 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote135 views3 answers
Java hide mysql login credentials
SQL
0 vote124 views1 answer
Compare field sql server
SQL
0 vote151 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote151 views1 answer
Drop primary key oracle
SQL