如何在Oracle中将字节字符串转换为数字？

Oracle

CONNECT BY

SELECT

WITH INPUT AS
(SELECT REVERSE(\'&N\') AS X FROM DUAL)
SELECT SUM(TO_NUMBER(SUBSTR(X,LEVEL,1)*POWER(2,LEVEL-1))) AS OUTPUT
FROM INPUT CONNECT BY LEVEL<=LENGTH(X);

select to_dec(\'1001\', 2) from dual;

SET SERVEROUTPUT ON;
DECLARE
  i VARCHAR2(100) := \'1001\';
  o INT;
BEGIN
  i:= TRIM(BOTH \',\' FROM REPLACE(REPLACE(i, \'1\', \'1,\'),\'0\',\'0,\')); 
  EXECUTE IMMEDIATE \'SELECT BIN_TO_NUM(\'|| i || \') FROM dual\' INTO o;
  DBMS_OUTPUT.put_line(i || \' => \' || o);
END;
/

1,0,0,1 => 9