Table of Contents
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;