本例用来计算18位身份证的校验位,绑定变量的值是身份证的前17位
select decode(12 - decode(wi,0,11,1,12,wi),10,'x',to_char(12 - decode(wi,0,11,1,12,wi))) wo
from (select mod(sum(substr('&a',level,1) * mod(power(2,18-rownum),11)),11) wi
from dual
connect by level <= length('&a'))
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8367589/viewspace-717140/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8367589/viewspace-717140/