17,377
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
lubin59 2004-07-18
- 打赏
- 举报
怎么这么高的信誉啊
myy 2004-07-18
- 打赏
- 举报
谢谢！
WilliamXiaoLiang 2004-07-18
- 打赏
- 举报
在论坛搜索一下，用“数据类型转换”作为关键字，以前看到过的
QQ:390958177
Email:xiaol@chinaebiz.biz
QQ:390958177
Email:xiaol@chinaebiz.biz
wolfAone 2004-07-18
- 打赏
- 举报
如何用sql实现字符型十六进制如何转换成十进制
select to_number('FFFF','xxxxxxxxxxxxxxx') from dual;
select to_number('FFFF','xxxxxxxxxxxxxxx') from dual;
wolfAone 2004-07-18
- 打赏
- 举报
select TO_NUMBER('ff','XXXXXXXXXXXXXXXXX') from dual
洪十二 2004-07-18
- 打赏
- 举报
select TO_NUMBER('FEEF','XXXXXX') from dual
65263
65263
万年水母 2004-07-18
- 打赏
- 举报
倒，还需要这么复杂啊。
select TO_NUMBER('ff','XXXXXX') from dual
select TO_NUMBER('ff','XXXXXX') from dual
atao245993 2004-07-18
- 打赏
- 举报
自己写函数转化,下面是一个例子:
create or replace FUNCTION hextodec (hexnum in char) RETURN number IS
x number;
digits number;
result number := 0;
current_digit char(1);
current_digit_dec number;
BEGIN
digits := length(hexnum);
for x in 1..digits loop
current_digit := upper(SUBSTR(hexnum, x, 1));
if current_digit in ('A','B','C','D','E','F') then
current_digit_dec := ascii(current_digit) - ascii('A') + 10;
else
current_digit_dec := to_number(current_digit);
end if;
result := (result * 16) + current_digit_dec;
end loop;
return result;
END;
create or replace FUNCTION hextodec (hexnum in char) RETURN number IS
x number;
digits number;
result number := 0;
current_digit char(1);
current_digit_dec number;
BEGIN
digits := length(hexnum);
for x in 1..digits loop
current_digit := upper(SUBSTR(hexnum, x, 1));
if current_digit in ('A','B','C','D','E','F') then
current_digit_dec := ascii(current_digit) - ascii('A') + 10;
else
current_digit_dec := to_number(current_digit);
end if;
result := (result * 16) + current_digit_dec;
end loop;
return result;
END;
beckhambobo 2004-07-17
- 打赏
- 举报
要作一个自定义函数转换，几年前有张贴子有所提及到，现在忘记了。
