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

2 votes222 views1 answer
Add default sql server
SQL
0 vote227 views1 answer
TSQL convert csv to table
SQL
4 votes180 views2 answers
Select todays data postgres query
SQL
0 vote222 views1 answer
Oracle select partition
SQL
1 vote221 views1 answer
Check if mysql is installed
SQL
3 votes227 views1 answer
Postgresql if null then 0
SQL
0 vote205 views1 answer
Wordpress sql change site url
SQL
0 vote246 views1 answer
Stratified sampling sql
SQL
-1 vote205 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
1 vote201 views1 answer
Psql show with user is logged in
SQL