Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle NVL2 function to HiRDB
HiRDB database doesn't supports NVL2 function but has its equivalent. SQLWays changes it to CASE construction.
Oracle:
select nvl2(col1,'str','str2') from t;
HiRDB:
select CASE WHEN col1 IS NOT NULL THEN 'str' ELSE 'str2' END from t;