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

4 votes142 views3 answers
Oracle sql first day of quarter
SQL
0 vote153 views1 answer
Get time component of datetime sql
SQL
8 votes158 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote148 views1 answer
Insufficient memory to excute the sql query
SQL
2 votes156 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
1 vote171 views2 answers
End mysql command
SQL
0 vote149 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
31 votes152 views3 answers
Sql count(*)
SQL
2 votes175 views3 answers
How do I add a user to a postgres database? cli
SQL
1 vote183 views3 answers
Reseed sql table primary key
SQL