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 };

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.