TO_CHAR(12345.67, '99999V99') : TO_CHAR « Conversion Functions « Oracle PL/SQL Tutorial





SQL> Select TO_CHAR(12345.67, '99999V99')  from dual;

TO_CHAR(
--------
 1234567










15.7.TO_CHAR
15.7.1.Format Parameters
15.7.2.TO_CHAR(x [, format]) converts x to a string.
15.7.3.TO_CHAR() will return a string of pound characters (#) if you try and format a number that contains too many digits for the format you have provided.
15.7.4.Use TO_CHAR() to convert columns containing numbers to strings.
15.7.5.TO_CHAR(12345.67, '99,999.99') (1)
15.7.6.TO_CHAR(12345.67, '99999.99') (2)
15.7.7.TO_CHAR(-12345.67, '99,999.99') (3)
15.7.8.TO_CHAR(12345.67, '099,999.99') (4)
15.7.9.TO_CHAR(12345.67, '99,999.9900')
15.7.10.TO_CHAR(12345.67, '$99,999.99')
15.7.11.TO_CHAR(0.67, 'B9.99')
15.7.12.TO_CHAR(12345.67, 'C99,999.99')
15.7.13.TO_CHAR(12345.67, '99999D99')
15.7.14.TO_CHAR(12345.67, '99999.99EEEE')
15.7.15.TO_CHAR(0012345.6700, 'FM99999.99')
15.7.16.TO_CHAR(12345.67, '99999G99')
15.7.17.TO_CHAR(12345.67, 'L99,999.99')
15.7.18.TO_CHAR(-12345.67, '99,999.99MI')
15.7.19.TO_CHAR(-12345.67, '99,999.99PR')
15.7.20.TO_CHAR(2007, 'RN')
15.7.21.TO_CHAR(12345.67, 'TM')
15.7.22.TO_CHAR(12345.67, 'U99,999.99')
15.7.23.TO_CHAR(12345.67, '99999V99')
15.7.24.TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi')
15.7.25.to_char(sysdate,'hh24:mi:ss') as time
15.7.26.to_char(to_date('01/01/2006','dd/mm/yyyy'),is on Day') as new_year_2006
15.7.27.to_char(sysdate, 'Day', 'nls_date_language=Dutch')
15.7.28.to_char(sysdate,'DAY dy Dy')
15.7.29.to_char(sysdate,'MONTH mon') as month
15.7.30.to_char(bdate,'fmMonth ddth, yyyy')
15.7.31.use to_char more than once to create long date format