分享
 
 
 

在Oracle中实现数字进制转换完全版

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

以下内容包括:

1).提供两个进制转换包

2).提供进制转换的一些简便方法

3).提供进制转换的不同方法的性能评估

1.两个进制转换包

1)包PKG_DM_BASE_CONV(推荐)

CREATE OR REPLACE PACKAGE PKG_DM_BASE_CONV AS

FUNCTION hex_to_dec (hexnum IN char) RETURN NUMBER;

PRAGMA restrict_references (HEX_TO_DEC,WNDS);

FUNCTION dec_to_hex (N IN NUMBER) RETURN VARCHAR2;

PRAGMA restrict_references (DEC_TO_HEX,WNDS);

FUNCTION oct_to_dec (octin IN NUMBER) RETURN NUMBER;

PRAGMA restrict_references (OCT_TO_DEC,WNDS);

FUNCTION dec_to_oct (decin IN NUMBER) RETURN VARCHAR2;

PRAGMA restrict_references (DEC_TO_OCT,WNDS);

FUNCTION bin_to_dec (binin IN NUMBER) RETURN NUMBER;

PRAGMA restrict_references (BIN_TO_DEC,WNDS);

FUNCTION dec_to_bin (decin IN NUMBER) RETURN VARCHAR2;

PRAGMA restrict_references (DEC_TO_BIN,WNDS);

FUNCTION hex_to_bin (hexin IN VARCHAR2) RETURN NUMBER;

PRAGMA restrict_references (HEX_TO_BIN,WNDS);

FUNCTION bin_to_hex (binin IN NUMBER) RETURN VARCHAR2;

PRAGMA restrict_references (BIN_TO_HEX,WNDS);

FUNCTION oct_to_bin (octin IN NUMBER) RETURN NUMBER;

PRAGMA restrict_references (OCT_TO_BIN,WNDS);

FUNCTION bin_to_oct (binin IN NUMBER) RETURN NUMBER;

PRAGMA restrict_references (BIN_TO_OCT,WNDS);

FUNCTION oct_to_hex (octin IN NUMBER) RETURN VARCHAR2;

PRAGMA restrict_references (OCT_TO_HEX,WNDS);

FUNCTION hex_to_oct (hexin IN VARCHAR2) RETURN NUMBER;

PRAGMA restrict_references (HEX_TO_OCT,WNDS);

--十六进制字符转换成ASCII码字符

FUNCTION raw_to_char(v_rawLONG RAW) RETURN VARCHAR2;

PRAGMA restrict_references (raw_to_char,WNDS);

--ASCII码字符转换成十六进制字符

FUNCTION char_to_raw(v_char varchar2) RETURN LONG RAW;

PRAGMA restrict_references (char_to_raw,WNDS);

END PKG_DM_BASE_CONV;

/

CREATE OR REPLACE PACKAGE BODY PKG_DM_BASE_CONV AS

FUNCTION hex_to_dec (hexnum in char) RETURN NUMBER IS

i NUMBER;

digitsNUMBER;

resultNUMBER := 0;

current_digit char(1);

current_digit_dec number;

BEGIN

digits := length(hexnum);

FOR i IN 1..digits LOOP

current_digit := SUBSTR(hexnum, i, 1);

IFcurrent_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 hex_to_dec;

FUNCTION dec_to_hex (N IN NUMBER) RETURN VARCHAR2 IS

HVARCHAR2(64) :='';

N2 INTEGER:= N;

BEGIN

LOOP

SELECT rawtohex(chr(N2))H

INTO H

FROM dual;

N2 := trunc(N2 / 256);

EXIT WHEN N2=0;

END LOOP;

RETURN H;

END dec_to_hex;

FUNCTION oct_to_dec (octin IN NUMBER) RETURN NUMBER IS

v_charpos NUMBER;

v_charval CHAR(1);

v_return NUMBER DEFAULT 0;

v_power NUMBER DEFAULT 0;

v_string VARCHAR2(2000);

BEGIN

v_string := TO_CHAR(octin);

v_charpos := LENGTH(v_string);

WHILE v_charpos 0 LOOP

v_charval := SUBSTR(v_string,v_charpos,1);

IF v_charval BETWEEN '0' AND '7' THEN

v_return := v_return + TO_NUMBER(v_charval) * POWER(8,v_power);

ELSE

raise_application_error(-20621,'Invalid input');

END IF;

v_charpos := v_charpos - 1;

v_power := v_power + 1;

END LOOP;

RETURN v_return;

END oct_to_dec;

FUNCTION dec_to_oct (decin IN NUMBER) RETURN VARCHAR2 IS

v_decin NUMBER;

v_next_digit NUMBER;

v_result varchar(2000);

BEGIN

v_decin := decin;

WHILE v_decin 0 LOOP

v_next_digit := mod(v_decin,8);

v_result := to_char(v_next_digit) v_result;

v_decin := floor(v_decin / 8);

END LOOP;

RETURN v_result;

END dec_to_oct;

FUNCTION bin_to_dec (binin IN NUMBER) RETURN NUMBER IS

v_charpos NUMBER;

v_charval CHAR(1);

v_return NUMBER DEFAULT 0;

v_power NUMBER DEFAULT 0;

v_string VARCHAR2(2000);

BEGIN

v_string := TO_CHAR(binin);

v_charpos := LENGTH(v_string);

WHILE v_charpos 0 LOOP

v_charval := SUBSTR(v_string,v_charpos,1);

IF v_charval BETWEEN '0' AND '1' THEN

v_return := v_return + TO_NUMBER(v_charval) * POWER(2,v_power);

ELSE

raise_application_error(-20621,'Invalid input');

END IF;

v_charpos := v_charpos - 1;

v_power := v_power + 1;

END LOOP;

RETURN v_return;

END bin_to_dec;

FUNCTION dec_to_bin (decin IN NUMBER) RETURN VARCHAR2 IS

v_decin NUMBER;

v_next_digit NUMBER;

v_result varchar(2000);

BEGIN

v_decin := decin;

WHILE v_decin 0 LOOP

v_next_digit := mod(v_decin,2);

v_result := to_char(v_next_digit) v_result;

v_decin := floor(v_decin / 2);

END LOOP;

RETURN v_result;

END dec_to_bin;

FUNCTION hex_to_bin (hexin IN VARCHAR2) RETURN NUMBER IS

BEGIN

RETURN dec_to_bin(hex_to_dec(hexin));

END hex_to_bin;

FUNCTION bin_to_hex (binin IN NUMBER) RETURN VARCHAR2 IS

BEGIN

RETURN dec_to_hex(bin_to_dec(binin));

END bin_to_hex;

FUNCTION oct_to_bin (octin IN NUMBER) RETURN NUMBER IS

BEGIN

RETURN dec_to_bin(oct_to_dec(octin));

END oct_to_bin;

FUNCTION bin_to_oct (binin IN NUMBER) RETURN NUMBER IS

BEGIN

RETURN dec_to_oct(bin_to_dec(binin));

END bin_to_oct;

FUNCTION oct_to_hex (octin IN NUMBER) RETURN VARCHAR2 IS

BEGIN

RETURN dec_to_hex(oct_to_dec(octin));

END oct_to_hex;

FUNCTION hex_to_oct (hexin IN VARCHAR2) RETURN NUMBER IS

BEGIN

RETURN dec_to_oct(hex_to_dec(hexin));

END hex_to_oct;

FUNCTION raw_to_char(v_raw LONG RAW) RETURN VARCHAR2 IS

rawlen NUMBER;

hexVARCHAR2(32760);

rawparam VARCHAR2(32760);

iNUMBER;

BEGIN

hex := rawtohex(v_raw);

rawlen := length(hex);

i := 1;

WHILE i <= rawlen

LOOP

rawparam := rawparamCHR(hex_to_dec(substrb(hex,i,2)));

i := i + 2;

END LOOP;

RETURN rawparam;

END raw_to_char;

FUNCTION char_to_raw(v_char varchar2) RETURN LONG RAW IS

rawdataLONG RAW;

rawlen NUMBER;

hexVARCHAR2(32760);

iNUMBER;

BEGIN

rawlen := length(v_char);

i := 1;

WHILE i <= rawlen

LOOP

hex:= dec_to_hex(ascii(substrb(v_char,i,1)));

rawdata := rawdata HEXTORAW(hex);

i := i + 1;

END LOOP;

RETURN rawdata;

END;

END PKG_DM_BASE_CONV;

/

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有