User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
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}]}];