| Function |
Description |
| BIGINT |
Returns a 64-bit integer representation of a value in the form of an integer constant. |
| BINARY |
Returns a fixed-length binary string representation of a string of any data type. |
| BLOB |
Returns a BLOB representation of a string of any type. |
| CHAR |
Returns a CHARACTER representation of a value. |
| CLOB |
Returns a CLOB representation of a value. |
| DATE |
Returns a DATE from a value. |
| DBCLOB |
Returns a DBCLOB representation of a string. |
| DECFLOAT |
Returns the decimal floating-point representation of a value. |
| DECIMAL or DEC |
Returns a DECIMAL representation of a value. |
| DOUBLE_PRECISION or DOUBLE |
Returns the floating-point representation of a value. |
| EMPTY_BLOB, EMPTY_CLOB, EMPTY_DBCLOB, and EMPTY_NCLOB s |
Return a zero-length value of the associated data type. |
| FLOAT |
Returns a DOUBLE representation of a value. |
| GRAPHIC |
Returns a GRAPHIC representation of a string. |
| INT |
Returns an INTEGER representation of a value. |
| INTEGER |
Returns an INTEGER representation of a value. |
| NCHAR |
Returns a fixed-length national character string representation of a value. |
| NCLOB |
Returns an NCLOB representation of a national character string. |
| NVARCHAR |
Returns a varying-length national character string representation of a value. |
| REAL |
Returns the single-precision floating-point representation of a value. |
| SMALLINT |
Returns a SMALLINT representation of a value. |
| TIME |
Returns a TIME from a value. |
| TIMESTAMP |
Returns a TIMESTAMP from a value or a pair of values. |
| TO_CLOB |
Returns a CLOB representation of a character string type. |
| TO_NCLOB |
Returns an NCLOB representation of a character string. |
| VARBINARY |
Returns a VARBINARY (varying-length binary string) representation of a string of any data type. |
| VARCHAR |
Returns a VARCHAR representation of a value. |
| VARGRAPHIC |
Returns a VARGRAPHIC representation of a value. |
