Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Variable Declaration to HiRDB
'NOT NULL' is not supported on HiRDB.So if 'NOT NULL' is specified , remove 'NOT NULL'. And ':=' fix 'DEFAULT'.
Oracle:
variable_name data_type [NOT NULL] [{:=|DEFAULT} default_value];
HiRDB:
DECLARE variable_name data_type [DEFAULT default_value] ;