Oracle insert from select

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 vote298 views1 answer
Plpgsql raise notice
SQL
0 vote284 views1 answer
Select count postgres double row count > 1
SQL
0 vote286 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
3 votes306 views1 answer
Sql case update
SQL
4 votes365 views3 answers
Mysql get column names from table
SQL
0 vote278 views2 answers
Mysql add days to date
SQL
0 vote301 views1 answer
Oracle current timestamp insert statement
SQL
1 vote284 views2 answers
Check if word is in column sql
SQL
0 vote297 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote307 views1 answer
Select sql in descending order
SQL