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

2 votes270 views2 answers
How to add not null constraint in sql
SQL
3 votes250 views1 answer
Mssql remove column
SQL
0 vote288 views1 answer
Get role postgres
SQL
0 vote274 views1 answer
Providername system.data. mysql
SQL
0 vote279 views1 answer
Primary key multiple
SQL
1 vote253 views1 answer
Oracle create_program
SQL
0 vote287 views2 answers
Generate sql trigger through ef migration
SQL
8 votes255 views1 answer
Oracle all_source package body
SQL
1 vote268 views1 answer
Second last highest id in sql
SQL
0 vote210 views2 answers
Delete the last item in a table sql
SQL