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

0 vote332 views1 answer
Sql server union if table exist
SQL
3 votes339 views2 answers
Postgres show table schema
SQL
0 vote345 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
10 votes356 views3 answers
Sql select between two dates
SQL
2 votes353 views1 answer
Q operator in plsql
SQL
0 vote352 views1 answer
Stored procedures example
SQL
1 vote315 views2 answers
Mysql spring boot application.properties
SQL
0 vote332 views2 answers
Mysql row_number() example
SQL
0 vote327 views2 answers
How to use aggregate functions in sql
SQL
-1 vote338 views2 answers
Sql convert date to string yyyy-mm-dd
SQL