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 vote197 views1 answer
Mysql changer nom table
SQL
-1 vote181 views1 answer
Ms sql select datetime as date
SQL
0 vote172 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote171 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote164 views2 answers
Add colum in sql
SQL
0 vote168 views1 answer
How to use query in nosql
SQL
0 vote168 views1 answer
Mariadb select limit offset
SQL
34 votes184 views5 answers
Oracle alter table add column
SQL
0 vote172 views1 answer
Mysql make date from 2 column
SQL
0 vote184 views1 answer
How to combine first and last nae into one columb sql
SQL