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

7 votes206 views6 answers
Mysql group concat
SQL
2 votes174 views1 answer
Oracle cpu per session
SQL
0 vote173 views1 answer
Using GROUP BY in MySQL Join Table
SQL
2 votes187 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
1 vote178 views1 answer
Sql drop with dependencies
SQL
0 vote196 views1 answer
Check for directory in bash
SQL
0 vote216 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote190 views4 answers
Sql rownum
SQL
2 votes236 views1 answer
How to get non distinct values in sql
SQL
1 vote188 views1 answer
Spark sql concatenate string and int
SQL