Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
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;
HiRDB:
SELECT DIGITS(-10000) FROM t;
To_char(number) with format
HiRDB has equivalent for To_char(number) with format. SQLWays changes it to NUMEDIT function.
Oracle:
SELECT TO_CHAR(-10000,'L99G999D99MI') FROM t; SELECT TO_CHAR(10000,'S99G999D99') FROM t;
HiRDB:
SELECT NUMEDIT(-10000,'L99G999D99MI') FROM t; SELECT NUMEDIT(10000,'+99G999D99') FROM t;
To_char(number) with nls_parameters
HiRDB hasn't equivalent for To_char(number) with nls_parameters. SQLWays leaves it as is and adds message /*Сould not convert ' TO_CHAR' */.
Oracle:
SELECT TO_CHAR(-10000,'L99G999D99MI', 'NLS_NUMERIC_CHARACTERS = '',.'') FROM t;
HiRDB:
SELECT TO_CHAR(-10000,'L99G999D99MI', 'NLS_NUMERIC_CHARACTERS = '',.'') FROM t; /* Сould not convert 'TO_CHAR' */