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

1 vote367 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
9 votes359 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote396 views1 answer
Postgresql print sessions using the database
SQL
9 votes341 views2 answers
Get first 3 letters in sql
SQL
4 votes422 views2 answers
Postgresql float data type
SQL
0 vote368 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
23 votes364 views3 answers
Mysqldump
SQL
1 vote342 views1 answer
Oracle first row
SQL
0 vote395 views1 answer
Postgresql find biggest table
SQL
1 vote353 views1 answer
Mysql count words
SQL