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 vote290 views1 answer
Creation d'un trigger sql
SQL
1 vote299 views1 answer
Sql server datetime vs datetime2
SQL
0 vote316 views1 answer
Check user sql password from command line
SQL
19 votes300 views5 answers
Change column name mysql command line
SQL
0 vote308 views1 answer
Mysql set variable to today's date
SQL
0 vote315 views1 answer
How to update date value in sql
SQL
3 votes283 views4 answers
Mysql delete duplicate rows
SQL
0 vote303 views1 answer
Every Derived yable must have its own alias
SQL
19 votes300 views2 answers
Mysql tinyint max value
SQL
0 vote297 views1 answer
Mysql repair a table
SQL