msql语句

-----二进制转换十进制-----------------
SELECT sum(data1)
  FROM (SELECT substr('1101', rownum, 1) * power
(2, length('1101') - rownum) data1
          FROM dual
        connect BY rownum <= length('1101'))

-----八进制转换十进制-----------------
SELECT sum(data1)
  FROM (SELECT substr('1101', rownum, 1) * power
(8, length('1101') - rownum) data1
          FROM dual
        connect BY rownum <= length('1101'))

-----十六进制转换十进制-----------------
SELECT sum(data1)
  FROM (SELECT (CASE upper(substr('2D', rownum, 1))
WHEN 'A' THEN '10'
WHEN 'B' THEN '11'
WHEN 'C' THEN '12'
WHEN 'D' THEN '13'
WHEN 'E' THEN '14'
WHEN 'F' THEN '15'
ELSE substr('2D', rownum, 1)
END) * power(16, length('2D') - rownum) data1
FROM dual
connect BY rownum <= length('2D'))