oracle实现身份证校验功能（Oracle to achieve authentication card function）.docVIP

下载本文档

6
0
约3.21千字
约 7页
2017-09-05 发布于河南
举报
版权申诉

oracle实现身份证校验功能（Oracle to achieve authentication card function）.doc

1、本文档共7页，可阅读全部内容。
2、原创力文档（book118）网站文档一经付费（服务费），不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。
3、本站所有内容均由合作方或网友上传，本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺！文档内容仅供研究参考，付费前请自行鉴别。如您付费，意味着您自己接受本站规则且自行承担风险，本站不退款、不进行额外附加服务；查看《如何避免下载的几个坑》。如果您已付费下载过本站文档，您可以点击这里二次下载。
4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“版权申诉”（推荐），也可以打举报电话：400-050-0827(电话支持时间：9:00-18:30)。
5、该文档为VIP文档，如果想要下载，成为VIP会员后，下载免费。
6、成为VIP后，下载本文档将扣除1次下载权益。下载后，不支持退款、换文档。如有疑问请联系我们。
7、成为VIP后，您将拥有八大权益，权益包括：VIP文档下载权益、阅读免打扰、文档格式转换、高级专利检索、专属身份标志、高级客服、多端互通、版权登记。
8、VIP文档为合作方或网友上传，每下载1次，网站将根据用户上传文档的质量评分、类型等，对文档贡献者给予高额补贴、流量扶持。如果你也想贡献VIP文档。上传文档

oracle实现身份证校验功能（Oracle to achieve authentication card function）

oracle实现身份证校验功能（Oracle to achieve authentication card function） Requirements: 1, enter a 18 digit ID number, to verify its effectiveness; The 2 part is the effective date of birth and date and eighteenth bit parity bit is correct is legitimate. ID number parity algorithm: 1: the first 17 numbers from the high to low and the following 17 digits are multiplied by the sum (N): 2,4,8,5,10,9,7,3,6,1,2,4,8,5,10,9,7. For example, ID number: C1C2C3...... C16C17 N = C17 * 2C16 * 4...... C1 * 7; 2: N will be divided by 11 mod R, calculate the parity bit according to the remainder of T: 1) if R = 0, T = 1; if R = 1, T = 0; if R = 2, T = X; 2) if R = 3, T = 9; if R = 4, T = 8 and so on...... ; if R = 10, T = 2; SET SERVEROUTPUT ON CREATE OR REPLACE PROCEDURE CHECK_CARD (p_card_number VARCHAR2) AS L_card_number VARCHAR2 (20); L_card_last VARCHAR2 (2); L_card_str VARCHAR2 (8); L_judge_str VARCHAR2 (20); L_judge_r VARCHAR2 (2); L_judge_t VARCHAR2 (2); L_count number (6); L_card_date date; BEGIN L_card_number:=trim (p_card_number); L_card_last:=trim (substr (l_card_number, 18,1)); L_judge_str:=trim (2485109736124851097); L_card_str:=trim (substr (l_card_number, 7,8)); L_card_date:=trim (to_date (l_card_str,yyyymmdd)); If length (l_card_number) 18 then Dbms_output.put_line (ID number is wrong, please input the ID number 18! ); Else L_count:= (substr (l_card_number, 17,1) * substr (l_judge_str, 1,1) + Substr (l_card_number, 16,1) * substr (l_judge_str, 2,1) + Substr (l_card_number, 15,1) * substr (l_judge_str, 3,1) + Substr (l_card_number, 14,1) * substr (l_judge_str, 4,1) + Substr (l_card_number, 13,1) * substr (l_judge_str, 5,2) + Substr (l_card_number, 12,1) * substr (l_judge_str, 7,1) + Substr (l_card_number, 11,1) * substr (l_judge_str, 8,1) + Substr (l_card_number, 10,1) * substr (l_judge_str, 9,1) + Substr (l_card_number, 9,1) * substr (l_judge_str, 10,1) + Substr (l_card_number, 8,1) * substr (l_judge_str, 11,1) + Substr (l_card_number, 7,1) * substr (l_judge_str, 12,1) + Sub