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

2 votes108 views6 answers
Mysql change timezone
SQL
0 vote103 views1 answer
Mysql trigger to delete old data
SQL
6 votes94 views2 answers
How to copy data in sql
SQL
0 vote118 views1 answer
How to change mysql root password in windows 10
SQL
2 votes108 views1 answer
Q operator in oracle
SQL
1 vote99 views1 answer
Mysql history command
SQL
1 vote146 views1 answer
SQL server query column yes or no
SQL
0 vote103 views1 answer
Delete a record from a table sqlite3
SQL
0 vote94 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote108 views1 answer
Oracle webcenter content search enginer
SQL