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;