EMS 校验规则
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.05.28 17:15
分类: 分销
出处: http://moonsoft.itpub.net/post/15182/290549
---------------------------------------------------------------
/* Formatted on 2007/05/28 17:01 (Formatter Plus v4.8.7) */
declare
v_char varchar2(13);
v_result varchar2(10);
begin
v_char:='EC186409676CN';
SELECT
( 11
- MOD (( 8 * TO_NUMBER (SUBSTR (v_char, 3, 1))
+ 6 * TO_NUMBER (SUBSTR (v_char, 4, 1))
+ 4 * TO_NUMBER (SUBSTR (v_char, 5, 1))
+ 2 * TO_NUMBER (SUBSTR (v_char, 6, 1))
+ 3 * TO_NUMBER (SUBSTR (v_char, 7, 1))
+ 5 * TO_NUMBER (SUBSTR (v_char, 8, 1))
+ 9 * TO_NUMBER (SUBSTR (v_char, 9, 1))
+ 7 * TO_NUMBER (SUBSTR (v_char, 10, 1))
),
11
)
) RESULT
into v_result
FROM dual;
dbms_output.put_line('result'|| v_result);
end ;
