——16进制转10进制,用to_number,里面的参数是16进制的数据,且参数用单引号括起
完成选择to_number (& # 39; ff # 39; & # 39; xx # 39;)双;
,
TO_NUMBER (& # 39; ff # 39;, & # 39; xx # 39;)
- - - - - - - - - - - - - - - - - - - - -
,,,,,,,,,,,,,,,,255
,
——10进制转16进制,用to_char,里面的参数是10进制的数据,且参数不用单引号括起
完成选择to_char (255 & # 39; xx # 39;)双;
,
TO_CHAR (255 & # 39; xx # 39;)
- - - - - - - - - - - - - - - - - -
ff
,
——如下报错因为要转换的16进制的数据宽度与格式串的xx宽度不一样
完成选择to_number (& # 39; 10 effff& # 39; & # 39; xx # 39;)双;
,
选择to_number (& # 39; 10 effff& # 39; & # 39; xx # 39;)双
,
ora - 01722:无效数字
,
——续上,修正二者宽度一致,不再报的错
完成选择to_number (& # 39; 10 effff& # 39; & # 39; xxxxxxx # 39;)双;
,
TO_NUMBER (& # 39; 10 effff& # 39; & # 39; xxxxxxx # 39;)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
,,,,,,,,,,,,,,,,,,,,,17760255
,
——格式串的宽度祝辞=要转化的数据宽度也可以
完成选择to_number (& # 39; 10 effff& # 39; & # 39; xxxxxxx # 39;)双;
,
TO_NUMBER (& # 39; 10 effff& # 39; & # 39; xxxxxxx # 39;)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
,,,,,,,,,,,,,,,,,,,,,17760255
,
完成选择to_number (& # 39; e # 39; & # 39; xxxxxxx # 39;)双;
,
TO_NUMBER (& # 39; e # 39;, & # 39; xxxxxxx # 39;)
- - - - - - - - - - - - - - - - - - - - - - - -
,,,,,,,,,,,,,,,,,,,,,14
,
- - - - - - - - - - - - - - - - -
版权声明:本文为CSDN博主”数据,amp;安全”的原创文章,遵循CC冲锋队4.0版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/w892824196/article/details/98938379