能帮我把这个语句转换为存储过程

Question

SELECT CASE WHEN SUBSTR(ID_NUM,7,4)NOT BETWEEN '1900' AND '2099' THEN '0'
WHEN SUBSTR(ID_NUM,11,2) NOT BETWEEN '01'AND'12' THEN '0'
WHEN SUBSTR(ID_NUM,13,2) NOT BETWEEN '01'AND'31' THEN '0'
WHEN SUBSTR(ID_NUM,1,2) NOT IN(11,12,13,14,15,21,22,23,31,32,33,34,35,36,37,41,42,43,44,45,46,51,52,53,54,50,61,62,63,64,65,83,81,82) THEN '0'
WHEN MOD((
SUBSTR(ID_NUM,1,1)*7+
SUBSTR(ID_NUM,2,1)*9+
SUBSTR(ID_NUM,3,1)*10+
SUBSTR(ID_NUM,4,1)*5+
SUBSTR(ID_NUM,5,1)*8+
SUBSTR(ID_NUM,6,1)*4+
SUBSTR(ID_NUM,7,1)*2+
SUBSTR(ID_NUM,8,1)*1+
SUBSTR(ID_NUM,9,1)*6+
SUBSTR(ID_NUM,10,1)*3+
SUBSTR(ID_NUM,11,1)*7+
SUBSTR(ID_NUM,12,1)*9+
SUBSTR(ID_NUM,13,1)*10+
SUBSTR(ID_NUM,14,1)*5+
SUBSTR(ID_NUM,15,1)*8+
SUBSTR(ID_NUM,16,1)*4+
SUBSTR(ID_NUM,17,1)*2),11)!=
(CASE WHEN SUBSTR(ID_NUM,18,1)='1' THEN 0
WHEN SUBSTR(ID_NUM,18,1)='0' THEN 1
WHEN SUBSTR(ID_NUM,18,1)='X' THEN 2
WHEN SUBSTR(ID_NUM,18,1)='9' THEN 3
WHEN SUBSTR(ID_NUM,18,1)='8' THEN 4
WHEN SUBSTR(ID_NUM,18,1)='7' THEN 5
WHEN SUBSTR(ID_NUM,18,1)='6' THEN 6
WHEN SUBSTR(ID_NUM,18,1)='5' THEN 7
WHEN SUBSTR(ID_NUM,18,1)='4' THEN 8
WHEN SUBSTR(ID_NUM,18,1)='3' THEN 9
WHEN SUBSTR(ID_NUM,18,1)='2' THEN 10 end) THEN '0' ELSE'1' end FROM DUAL

2. ---

Answer 1

你好，我是有问必答小助手，非常抱歉，本次您提出的有问必答问题，技术专家团超时未为您做出解答


本次提问扣除的有问必答次数，将会以问答VIP体验卡（1次有问必答机会、商城购买实体图书享受95折优惠）的形式为您补发到账户。


因为有问必答VIP体验卡有效期仅有1天，您在需要使用的时候【私信】联系我，我会为您补发。