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

8 votes133 views2 answers
Safe update mode in mysql
SQL
10 votes122 views5 answers
Create table mysql query
SQL
0 vote146 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote118 views1 answer
Oracle gather table statistics
SQL
4 votes120 views1 answer
Oracle show error line number
SQL
4 votes137 views3 answers
Is not null sql
SQL
0 vote140 views1 answer
Order child below the parent in mysqli
SQL
5 votes118 views4 answers
Rollback to in sql
SQL
16 votes129 views3 answers
T-SQL Add Column
SQL
0 vote127 views1 answer
Sqlplus change user
SQL