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 votes385 views2 answers
Spring import sql
SQL
0 vote399 views1 answer
Mariadb create index if not exists
SQL
0 vote341 views1 answer
Codeigniter dbforge add index
SQL
24 votes359 views4 answers
Mysql datetime
SQL
4 votes356 views1 answer
Search column by name mysql
SQL
0 vote343 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote346 views1 answer
Mysql set boolean default value
SQL
0 vote349 views1 answer
Sql gap missing values
SQL
15 votes526 views2 answers
Sql order by alphabetical
SQL
0 vote350 views1 answer
Services.AddDbContext DataSource Sqlite
SQL