Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle INSERT INTO to HiRDB
If “@dblink_name” is specified , remove “@dblink_name” Also if using 'subquery' after INTO token specified , add warning message “Could not convert ” + “ this syntax”.
Oracle:
INSERT INTO {[ schema_name.]table_name[@dblink_name] | (subquery1) | TABLE(subquery2)} [(column_name, …)] {VALUES(value, …) |subquery };
HiRDB:
INSERT INTO {[ schema_name.]table_name} [(column_name, …)] {VALUES(value, …) |subquery };