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; 

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