Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle DELETE to HiRDB

If “FROM” token was omitted , add “FROM” token. And if “@dblink_name” is specified , remove “@dblink” TOKEN. If using 'subquery' , add warning message “Could not convert ” + “ this syntax”.

Oracle:

DELETE [FROM]
{table[@dblink_name] |  (subquery) | TABLE(subquery)}
[WHERE {condition | CURRENT OF cursor_name}]
[RETURNING clause];

HiRDB:

DELETE FROM
{table}
[WHERE {condition | CURRENT OF cursor_name}]
[RETURNING clause];

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