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 vote130 views1 answer
Import big data to mysql
SQL
1 vote150 views1 answer
How to truncate a table in databse
SQL
0 vote147 views1 answer
Sql select where more than one record exists
SQL
0 vote148 views2 answers
SQL FROM
SQL
0 vote142 views1 answer
T-sql update table variale
SQL
-1 vote172 views1 answer
Sql show custom constraints
SQL
0 vote161 views1 answer
Oracle current date minus 1 day
SQL
0 vote126 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote153 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote146 views1 answer
Sql put two columns into one
SQL