Oracle insert into where

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

1 vote308 views1 answer
Mysql copy table1 to table2
SQL
6 votes316 views2 answers
Mysql interval 1 day
SQL
1 vote318 views1 answer
Is sql fast
SQL
0 vote312 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
3 votes348 views1 answer
Where id is in list sql
SQL
-1 vote286 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
4 votes335 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote347 views1 answer
"Hello User Name"
SQL
0 vote289 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote288 views1 answer
INSERT INTO table using OpenQuery
SQL