SQL Server
SELECT INTO statement can
insert rows into a table. This construct, which is part SELECT and part INSERT, is not
supported by ANSI. Replace these statements with INSERT...SELECT statements in
Oracle.
SELECT col1, col2, col3
INTO target_table
FROM source_table
WHERE where_clause
Oracle:
INSERT into target_table
SELECT col1, col2, col3
FROM source_table
WHERE where_clause