TO_CHAR (character)

TO_CHAR(character) converts a text expression to the database character set.

Return Value

VARCHAR2

Syntax

TO_CHAR(nchar | clob | nclob)

Arguments

nchar, clob, or nclob is a text expression. If it contains characters that are not represented in the database character set, then the conversion results in a loss of data.

Example

TO_CHAR( 'David Ortiz') returns the value David Ortiz in the database character set.