The TO_CHAR() function converts the expression into character data. : TO_CHAR « Conversion Functions « Oracle PL / SQL






The TO_CHAR() function converts the expression into character data.

   

Syntax: TO_CHAR(<expression> [,[FORMAT] [,NLS_PARAM]] )
SQL>
SQL> SELECT
  2     LENGTHB(NCHR(216))  national,
  3     LENGTHB(TO_CHAR(NCHR(216))) converted
  4  FROM dual;

  NATIONAL  CONVERTED
---------- ----------
         2          1

   
    
  








Related examples in the same category

1.Pass variable into to_char function
2.Use to_char function to init an text value
3.convert a negative number into one with a trailing "minus sign,"
4.to_char(bdate,'fmMonth ddth, yyyy')
5.to_char(round(sqrt(sal),2),'9999.99')
6.to_char(sysdate, 'Day', 'nls_date_language=Dutch')
7.to_char(sysdate,'DAY dy Dy') as day, to_char(sysdate,'MONTH mon') as month
8.to_char(sysdate,'hh24:mi:ss') as time
9.CONVERSION functions: Print the current date/time as a character string and modifies the format