【进制转换】十进制与十六进制相互转换方法

Oracle提供的to_char和to_number函数在进制转换上也有贡献。简单演示一下。

1.使用TO_CHAR函数将十进制数转换为十六进制数的方法和效果如下
sec@ora10g> select TO_CHAR (1, 'XX') as "1",
  2         TO_CHAR (2, 'XX') as "2",
  3         TO_CHAR (3, 'XX') as "3",
  4         TO_CHAR (4, 'XX') as "4",
  5         TO_CHAR (5, 'XX') as "5",
  6         TO_CHAR (6, 'XX') as "6",
  7         TO_CHAR (7, 'XX') as "7",
  8         TO_CHAR (8, 'XX') as "8",
  9         TO_CHAR (9, 'XX') as "9",
 10         TO_CHAR (10, 'XX') as "10",
 11         TO_CHAR (11, 'XX') as "11",
 12         TO_CHAR (12, 'XX') as "12",
 13         TO_CHAR (13, 'XX') as "13",
 14         TO_CHAR (14, 'XX') as "14",
 15         TO_CHAR (15, 'XX') as "15",
 16         TO_CHAR (16, 'XX') as "16",
 17         TO_CHAR (17, 'XX') as "17"
 18    from DUAL;

  1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17
--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
  1   2   3   4   5   6   7   8   9   A   B   C   D   E   F  10  11
 
2.反过来，使用TO_NUMBER函数将十六进制数转换为十进制数的方法和效果如下
sec@ora10g> select TO_NUMBER ('1', 'XX') as "1",
  2         TO_NUMBER ('2', 'XX') as "2",
  3         TO_NUMBER ('3', 'XX') as "3",
  4         TO_NUMBER ('4', 'XX') as "4",
  5         TO_NUMBER ('5', 'XX') as "5",
  6         TO_NUMBER ('6', 'XX') as "6",
  7         TO_NUMBER ('7', 'XX') as "7",
  8         TO_NUMBER ('8', 'XX') as "8",
  9         TO_NUMBER ('9', 'XX') as "9",
 10         TO_NUMBER ('A', 'XX') as "A",
 11         TO_NUMBER ('B', 'XX') as "B",
 12         TO_NUMBER ('C', 'XX') as "C",
 13         TO_NUMBER ('D', 'XX') as "D",
 14         TO_NUMBER ('E', 'XX') as "E",
 15         TO_NUMBER ('F', 'XX') as "F",
 16         TO_NUMBER ('10', 'XX') as "10",
 17         TO_NUMBER ('11', 'XX') as "11"
 18    from DUAL;

  1   2   3   4   5   6   7   8   9   A   B   C   D   E   F  10  11
--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
  1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17

演示完毕。

-- The End --

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/519536/viewspace-620447/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/519536/viewspace-620447/