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

5 votes192 views2 answers
Postgresql add not null constraint
SQL
3 votes177 views1 answer
Oracle drop user
SQL
6 votes223 views3 answers
Mysql remove user privileges
SQL
14 votes169 views1 answer
Excel
SQL
0 vote190 views1 answer
Update sqlite
SQL
0 vote153 views1 answer
QCompleter con sql
SQL
6 votes163 views1 answer
Phpmyadmin reset root password
SQL
1 vote227 views1 answer
Top 10 rows in mysql
SQL
5 votes253 views4 answers
Restart the psql server windows
SQL
0 vote167 views1 answer
Tsql delete all rows
SQL