oracle+to+hex,Oracle:如何在Oracle SQL中將十六進制轉換為十進制?

3

FTA: Oracle to Decimal:

CREATE OR REPLACE FUNCTION hex2dec (hexnum IN CHAR) RETURN NUMBER IS

i NUMBER;

digits NUMBER;

result NUMBER := 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);

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 hex2dec;

/

show errors

CREATE OR REPLACE FUNCTION num2hex (N IN NUMBER) RETURN VARCHAR2 IS

H VARCHAR2(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 num2hex;

/

show errors