https://wiki.ispirer.com/ 2026-04-14T20:21:56+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/conversion-functions/asciistr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle ASCIISTR function to HiRDB HiRDB hasn't equivalents for ASCIISTR function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'ASCIISTR' */. Oracle: n := ASCIISTR(a); HiRDB: SET n = ASCIISTR(a); /* SQLWays: Could not convert 'ASCIISTR' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/bin-to-num?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle BIN_TO_NUM function to HiRDB HiRDB hasn't equivalents for BIN_TO_NUM function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'BIN_TO_NUM' */. Oracle: n := BIN_TO_NUM(a); HiRDB: SET n = BIN_TO_NUM(a); /* SQLWays: Could not convert 'BIN_TO_NUM' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/cast?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CAST function to HiRDB HiRDB database supports CAST function. SQLWays leaves it as is. Data type is converted based on data type's conversion rules. Oracle: SELECT CAST(col1 as NUMBER) FROM t; HiRDB: SELECT CAST(col1 as FLOAT) 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/conversion-functions/chartorowid?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CHARTOROWID function to HiRDB HiRDB hasn't equivalents for CHARTOROWID function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'CHARTOROWID' */. Oracle: n := CHARTOROWID(a); HiRDB: SET n = CHARTOROWID(a); /* SQLWays: Could not convert 'CHARTOROWID' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/compose?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle COMPOSE function to HiRDB HiRDB hasn't equivalents for COMPOSE function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'COMPOSE' */. Oracle: n := COMPOSE(a); HiRDB: SET n = COMPOSE(a); /* SQLWays: Could not convert 'COMPOSE' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/convert?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CONVERT function to HiRDB HiRDB hasn't equivalents for CONVERT function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'CONVERT' */. Oracle: n := CONVERT(col1, 'US7ASCII', 'WE8ISO8859P1'); HiRDB: SET n = CONVERT(col1, 'US7ASCII', 'WE8ISO8859P1'); /* SQLWays: Could not convert 'CONVERT' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/decode?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DECODE function to HiRDB SQLWays converts DECODE function to CASE expression. Oracle: SELECT DECODE(warehouse_id, 1, 'Southlake', 2, 'San Francisco', 'Non domestic') FROM inventories; HiRDB: SELECT CASE warehouse_id WHEN 1 THEN 'Southlake' WHEN 2 THEN 'San Francisco' ELSE 'Non domestic' END FROM inventories; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/decompose?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DECOMPOSE function to HiRDB HiRDB hasn't equivalents for DECOMPOSE function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'DECOMPOSE' */. Oracle: n := DECOMPOSE(a); HiRDB: SET n = DECOMPOSE(a); /* SQLWays: Could not convert 'DECOMPOSE' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/dump?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DUMP function to HiRDB HiRDB hasn't equivalents for DUMP function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'DUMP' */. Oracle: select dump('abc', 1016) from t; HiRDB: select dump('abc', 1016) from t; /* SQLWays: Could not convert 'dump' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/hextoraw?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle HEXTORAW function to HiRDB HiRDB hasn't equivalents for HEXTORAW function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'HEXTORAW' */. Oracle: select hextoraw(col1) from t; HiRDB: select hextoraw(col1) from t; /* SQLWays: Could not convert 'hextoraw' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/numtodsinterval?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NUMTODSINTERVAL function to HiRDB HiRDB hasn't equivalents for NUMTODSINTERVAL function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'NUMTODSINTERVAL' */. Oracle: select numtodsinterval(99,'day') from t; HiRDB: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/numtoyminterval?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NUMTOYMINTERVAL function to HiRDB HiRDB hasn't equivalents for NUMTOYMINTERVAL function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'NUMTOYMINTERVAL' */. Oracle: select numtoyminterval(99,'year') from t; HiRDB: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/ora-hash?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle ORA_HASH function to HiRDB HiRDB hasn't equivalents for ORA_HASH function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'ORA_HASH' */. Oracle: select ora_hash(col1, 99, 5) from t; HiRDB: select ora_hash(col1, 99, 5) from t; /* SQLWays: Could not convert 'ora_hash' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/rawtohex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RAWTOHEX function to HiRDB HiRDB hasn't equivalents for RAWTOHEX function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'RAWTOHEX' */. Oracle: select rawtohex(c1) from t; HiRDB: select rawtohex(c1) from t; /* SQLWays: Could not convert 'rawtohex' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-binary-double?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle TO_BINARY_DOUBLE function to HiRDB HiRDB hasn't equivalents for TO_BINARY_DOUBLE function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'TO_BINARY_DOUBLE' */. Oracle: select to_binary_double(c1) from t; HiRDB: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-binary-float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle TO_BINARY_FLOAT function to HiRDB HiRDB hasn't equivalents for TO_BINARY_FLOAT function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'TO_BINARY_FLOAT' */. Oracle: select to_binary_float(c1) from t; HiRDB: select to_binary_float(c1) from t; /* SQLWays: Could not convert 'to_binary_float' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-char-character?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_char(character) function to HiRDB To_char(str | clob | nclob) function HiRDB has equivalent for To_char(str | clob | nclob) function. SQLWays changes it to CAST function. Oracle: SELECT TO_CHAR('1101') FROM t; HiRDB: SELECT CAST('1101' AS MVARCHAR(255)) 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/conversion-functions/to-char-datetime?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_char(date) function to HiRDB To_char(date) function without nls_parameters HiRDB has equivalent for To_char(date) function without nls_parameters. SQLWays changes it to VARCHAR_FORMAT function. Oracle: SELECT TO_CHAR(current_date), TO_CHAR(current_date, 'IY-MM-DD HH24:MI:SS'), TO_CHAR(current_date, 'RRRR-MM-DD HH24:MI:SS') , TO_CHAR(current_date, 'IYYY-MM-DD HH24:MI:SS') from to_char_tab; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-char-number?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_char(number) function to HiRDB To_char(number) without format and nls_parameters HiRDB has equivalent for To_char(number) without format and nls_parameters. SQLWays changes it to DIGITS function. Oracle: SELECT TO_CHAR(-10000) 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/conversion-functions/to-clob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle TO_CLOB function to HiRDB HiRDB hasn't equivalents for TO_CLOB function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'TO_CLOB' */. Oracle: select to_clob('abc') from t; HiRDB: select to_clob('abc') from t; /* SQLWays: Could not convert 'to_clob' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_date function to HiRDB To_date function without nls_parameters HiRDB has equivalent for To_date function without nls_parameters. SQLWays changes it to DATE function. Oracle: SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.') 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/conversion-functions/to-dsinterval?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_dsinterval function to HiRDB HiRDB hasn't equivalent for To_dsinterval function. SQLWays leaves it as is and adds message /*Сould not convert 'to_dsinterval'*/. Oracle: select to_dsinterval(c1) from t; HiRDB: select to_dsinterval(c1) from t; /* Сould not convert 'to_dsinterval' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-lob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_lob function to HiRDB HiRDB hasn't equivalent for To_lob function. SQLWays leaves it as is and adds message /*Сould not convert 'to_lob'*/. Oracle: select to_lob(c1) from t; HiRDB: select to_lob(c1) from t; /* Сould not convert 'to_lob' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-nclob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_nclob function to HiRDB HiRDB hasn't equivalent for To_nclob function. SQLWays leaves it as is and adds message /*Сould not convert 'to_nclob'*/. Oracle: select to_nclob(c1) from t; HiRDB: select to_nclob(c1) from t; /* Сould not convert 'to_nclob' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/to-timestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle To_timestamp function to HiRDB To_timestamp function without nls_parameters HiRDB database doesn't support TO_TIMESTAMP function without nls_parameters. SQLWays changes it to equivalent function timestamp_format. Oracle: SELECT TO_TIMESTAMP('10-Sep-02 14:10:10.123000', 'DD-Mon-RR HH24:MI:SS.FF') 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/conversion-functions/translate-using?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Translate…Using function to HiRDB Translate…Using HiRDB hasn't equivalent for Translate…Using function. SQLWays leaves it as is and adds message /*Сould not convert ' TRANSLATE '*/. Oracle: SELECT TRANSLATE(nchar_col USING CHAR_CS) 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/conversion-functions/unistr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Unistr function to HiRDB HiRDB hasn't equivalent for Unistr function. SQLWays leaves it as is and adds message /*Сould not convert ' Unistr '*/. Oracle: SELECT UNISTR('abc\00e5\00f1\00f6') FROM t; HiRDB: SELECT UNISTR('abc\00e5\00f1\00f6') FROM t; /* Сould not convert 'UNISTR' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/conversion-functions/vsize?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Vsize function to HiRDB HiRDB has equivalent for Vsize. SQLWays changes it to length function and adds message /*This conversion has inappropriate possibility*/. Oracle: SELECT vsize(c1) FROM t; HiRDB: SELECT length(c1) FROM t; /*This conversion has inappropriate possibility*/