| 
       | 
    
 Convert an expression to a character String
to_char(expression[,'format'[,nls_format)
 You can convert a DATE, NUMBER or expression 
  into a character string.
  
  The format may be either a CHAR format or a NUMBER 
  format as required.
  
  If no format is specified Oracle will use the default date format.
  nls_format allows international formats to be applied.
  
additional query terms:
  tochar