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 vote193 views1 answer
Set root password mysql xampp
SQL
2 votes213 views3 answers
Row number mysql
SQL
1 vote188 views1 answer
Create new table in SQL from old table with data
SQL
0 vote177 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote177 views1 answer
Date on SQL
SQL
14 votes201 views4 answers
Sql compiler
SQL
0 vote211 views1 answer
Psql check if sql script is valid
SQL
2 votes177 views1 answer
Oracle sql drop table purge
SQL
11 votes190 views5 answers
How to install sqlite3 python
SQL
1 vote185 views1 answer
Pagination sql
SQL