问一个10进制转16进制的问题

to_char(255,'XXXXXX')结果是FF,但length是6？
是7吧
to_char(255,'XX')结果是FF,但length是3

解决方案 »

  1.   

    SQL> select length(trim(to_char(255,'XXXXXX'))) from dual;LENGTH(TRIM(TO_CHAR(255,'XXXXX
    ------------------------------
                                 2SQL> select length(trim(to_char(255,'XX'))) from dual;LENGTH(TRIM(TO_CHAR(255,'XX'))
    ------------------------------
                                 2SQL> select length(trim(to_char(15,'XX'))) from dual;LENGTH(TRIM(TO_CHAR(15,'XX')))
    ------------------------------
                                 1
      

  2.   

    SQL> select length(to_char(16,'XXXXXX')) from dual;LENGTH(TO_CHAR(16,'XXXXXX'))
    ----------------------------
                               7