Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

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;

HiRDB:

SELECT TRANSLATE(nchar_col USING CHAR_CS) FROM t;
/*Сould not convert ' TRANSLATE '*/

Translate without using

HiRDB database doesn't support Translate without using. SQLWays changes it to TRANSL_LONG function.

Oracle:

SELECT TRANSLATE('SQL*Plus User''s Guide', ' */''', '___') FROM t;

HiRDB:

SELECT TRANSL_LONG('SQL*Plus User''s Guide', ' */''', '___') FROM t;

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