【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:070.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
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('1101'))