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