https://wiki.ispirer.com/ 2026-04-15T08:17:35+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/coalesce?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle COALESCE function to HiRDB HiRDB database supports COALESCE function. SQLWays leaves it as is. Oracle: n := COALESCE(a,b); HiRDB: SET n = COALESCE(a,b); References in Wiki Database Reference Oracle COALESCE HiRDB COALESCE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/empty-blob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle EMPTY_BLOB function to HiRDB HiRDB hasn't equivalents for EMPTY_BLOB function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'EMPTY_BLOB' */. Oracle: select empty_blob from t; HiRDB: select empty_blob from t; /* SQLWays: Could not convert 'EMPTY_BLOB' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/empty-clob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle EMPTY_CLOB function to HiRDB HiRDB hasn't equivalents for EMPTY_CLOB function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'EMPTY_CLOB' */. Oracle: select empty_clob from t; HiRDB: select empty_clob from t; /* SQLWays: Could not convert 'EMPTY_CLOB' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/greatest?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Greatest function to HiRDB Greatest function without ? parameters HiRDB database supports Greatest function without ? parameters. SQLWays changes greatest function with arguments count more than 3 to greatest function with 3 arguments, which contains greatest functions. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/least?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Least function to HiRDB Least function HiRDB database supports Least function. SQLWays changes Least function with arguments count more than 3 to Least function with 3 arguments, which contains Least functions. Oracle: SELECT LEAST ('HARRY', 'HARRIOT', 'HAROLD'), LEAST ('HARRY', 'HARRIOT', 'HAROLD', 'HOHO') FROM t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/lnnvl?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LNNVL function to HiRDB HiRDB hasn't equivalents for LNNVL function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'LNNVL' */. Oracle: select * from t where lnnvl(col1 > 2); HiRDB: select * from t where lnnvl(col1 > 2); /* SQLWays: Could not convert 'lnnvl' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/make-ref?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle MAKE_REF function to HiRDB HiRDB hasn't equivalents for MAKE_REF function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'MAKE_REF' */. Oracle: select make_ref(col1,3003) from t; HiRDB: select make_ref(col1,3003) from t; /* SQLWays: Could not convert 'make_ref' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/nullif?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NULLIF function to HiRDB HiRDB database supports NULLIF function. SQLWays leaves it as is. Oracle: select NULLIF(col1,col2) from t; HiRDB: select NULLIF(col1,col2) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/nvl2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/other-functions/value?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Value function to HiRDB HiRDB hasn't equivalent for Value function. SQLWays leaves it as is and adds message /*Сould not convert ' Value '*/. Oracle: SELECT value(al) FROM t; HiRDB: SELECT value(al) FROM t; /* Сould not convert 'value' */