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 vote141 views1 answer
Sql developer connect to sql server
SQL
17 votes145 views4 answers
Set mysql Password
SQL
0 vote161 views1 answer
Drop all data from tables
SQL
0 vote131 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
3 votes138 views1 answer
Select nextval from sequence sql
SQL
0 vote143 views1 answer
Create domain sql
SQL
0 vote236 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote137 views1 answer
Get current date data in mysql
SQL
22 votes125 views2 answers
Mysql show all tables
SQL
0 vote135 views3 answers
Sql all columns
SQL