Excuse me everybody how to use Oracle SQL regular expression under check including even accounts, credit card, cash card, unionpay card, foreign currency card the card number of the bank account, ask for help

CodePudding user response:

Regexp_instr (col_name, '\' D ')=0 well probably just let it be, check whether all is digital, digital returns 0

CodePudding user response:

This kind of situation can only verify his digits and pure digital?

CodePudding user response:

Don't verify figures, just pure digital
Verify the digit length (col_name)=15

CodePudding user response:

Verify the bank card number oh, can't only 15

CodePudding user response:

reference 4 floor weixin_45401270 response:

validation bank card number oh, can't only 15

Bank card do not match the figures, some 16 some 19, the judge

CodePudding user response:

How to determine the probability account