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 votes169 views1 answer
Ora-00054 find lock
SQL
0 vote240 views5 answers
Right join
SQL
0 vote201 views1 answer
Drop table BigQuery table columns
SQL
3 votes231 views1 answer
Oracle detect invalid password
SQL
0 vote159 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
3 votes174 views2 answers
Oracle synonym
SQL
1 vote183 views1 answer
Sql padd let with zeros
SQL
0 vote167 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote175 views1 answer
Oracle drop default value
SQL
0 vote187 views1 answer
Look at running processes redshift
SQL