Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle CONSTANT declaration to HiRDB

'NOT NULL' is not supported on HiRDB.So if 'NOT NULL' is specified , remove 'NOT NULL'. And ':=' fix 'DEFAULT'.

Oracle:

constant_name CONSTANT data_ type
[NOT NULL]
{:=|DEFAULT} default_value;

HiRDB:

DECLARE constant_name data_type
[DEFAULT default_value] ;

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