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

36 votes307 views6 answers
Change column data type sql
SQL
0 vote205 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote229 views1 answer
Update sql sintax
SQL
0 vote182 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote206 views1 answer
T sql dynamic top n query
SQL
1 vote223 views1 answer
Postgresql create table with timestamp
SQL
0 vote216 views4 answers
What is unique key in sql
SQL
1 vote195 views2 answers
Backup table mssql
SQL
2 votes154 views4 answers
Mysql change database character set to utf8mb4
SQL
3 votes243 views1 answer
Flutter sqlite auto incrementing id primary key
SQL