DRAFT

Omnidex SQL Function: CHR

QuickLinks Statements Functions OdxSQL
See Also: CHR INSTR NEW_TIME NVL SUBSTR SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TO_DATE TO_NUMBER

Description

The CHR function returns the character with the specified ascii value and the return data type as a STRING size of 1 character.

This function is only available when the CREATE ENVIRONMENT statement contains the SQL_SYNTAX ORACLE clause or the SET SQL_SYNTAX ORACLE setting is set programmatically.

Syntax

CHR(integer-expression)

Examples

select chr(60) from trans_table;