摘要:
转自:http://www.eygle.com/archives/2004/06/oracle_howto_convert.html1.16进制转换为10进制可以通过to_number函数实现SQL> select to_number('19f','xxx') from dual;TO_NUMBER('19F','XXX')----------------------415SQL> select to_number('f','xx') from dual;TO_NUMBER('F 阅读全文