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 vote355 views1 answer
Oracle change password expiration policy
SQL
2 votes370 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote338 views1 answer
Json_remove mysql
SQL
2 votes345 views1 answer
Anonymous block plsql
SQL
0 vote385 views1 answer
Gcloud sql instance list
SQL
0 vote387 views1 answer
Mysql last friday of current month
SQL
3 votes335 views1 answer
Oracle nextval
SQL
3 votes370 views1 answer
Mysql insert on dupèlicate
SQL
5 votes328 views2 answers
Ranking functions in sql
SQL
8 votes386 views1 answer
Oracle search stored procedures for text
SQL