15位身份证升18位身份证的Oracle函数(二)
,'8','4','9','3','10','2')
into ll_sfz
from dual;
var_sfz18 := var_aac002 || ll_sfz;
return var_sfz18;
end if;
end func_aac00215_18;
/
show errors;
使用如下:
[sql]
SELECT func_aac00215_18('371102841104258') FROM dual;