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 vote102 views1 answer
Online sql testing tool
SQL
3 votes105 views1 answer
Oracle get trigger ddl
SQL
0 vote129 views2 answers
Compound operator in sql
SQL
2 votes114 views1 answer
Oracle trace session
SQL
23 votes126 views2 answers
Query to delete a database in mysql
SQL
0 vote128 views1 answer
Postgres enumerated type
SQL
0 vote74 views1 answer
Mysql convert column to uppercase
SQL
0 vote123 views2 answers
Oracle chain rules
SQL
1 vote133 views1 answer
Insert pg result of select
SQL
0 vote152 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL