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 vote132 views1 answer
Find invalid datetime field
SQL
12 votes163 views6 answers
How to install sqlite3 in python
SQL
0 vote135 views1 answer
Enable full text search mysql
SQL
2 votes130 views2 answers
Created at and updated at in mysql
SQL
0 vote135 views1 answer
Kill thread
SQL
3 votes100 views2 answers
Coalesce mysql
SQL
0 vote142 views1 answer
Plsql check for string in numeric
SQL
1 vote134 views1 answer
Oracle create program if no exists
SQL
0 vote135 views1 answer
Insert ip address in mysql
SQL
0 vote180 views1 answer
Mysql readable output
SQL