Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle UPDATE to HiRDB
If “@dblink_name” is specified , remove “@dblink_name” Also if using 'subquery' after UPDATE token specified , add warning message “Could not convert ” + “ this syntax”.
Oracle:
UPDATE {[schema_name.]table_name[@dblink_name] | (subquery) | TABLE(subquery2)} SET {column_name = {expr | subquery3 }| (column_name[, …]) = subquery4 }[, …] [WHERE {condition | CURRENT OF cursor_name}]}];
HiRDB:
UPDATE {[schema_name.]table_name} SET {column_name = {expr | subquery3 } | (column_name[, …]) = subquery4 }[, …] [WHERE {condition | CURRENT OF cursor_name}]}];