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

1 vote115 views1 answer
Mysql month name extract
SQL
0 vote104 views1 answer
List all permissions on a table in postgres
SQL
0 vote75 views1 answer
Mysql offset from bottom
SQL
1 vote110 views1 answer
Sql eliminare un record
SQL
0 vote105 views1 answer
Django mssql backend
SQL
7 votes115 views2 answers
N highest salary in sql
SQL
16 votes117 views1 answer
CTE statement sql server
SQL
0 vote118 views1 answer
Add SuperUser MySQL
SQL
3 votes107 views2 answers
Find the median in sql
SQL
0 vote99 views1 answer
Oracle tablespace autoextend
SQL