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

12 votes155 views6 answers
How to install sqlite3 in python
SQL
0 vote124 views1 answer
How to select only a certain date sql
SQL
5 votes118 views2 answers
Oracle to_timestamp
SQL
1 vote173 views4 answers
Alter schema sql
SQL
0 vote136 views1 answer
Regex any word except sql
SQL
14 votes131 views1 answer
Sql value of string
SQL
2 votes148 views1 answer
Oracle kill session by sql_id
SQL
1 vote169 views1 answer
Size of all tables in a schema oracle
SQL
0 vote212 views1 answer
Oracle sql alter view add column
SQL
0 vote136 views1 answer
Oracle last connexion
SQL