주민등록번호 오라클 검사 처리

SELECT  DECODE(
        REGEXP_COUNT( 
        :ARG
        , '^[0-9]{2}(?0[1-9]|1[0-2])(?0[1-9]|[1,2][0-9]|3[0-1])[1-4][0-9]{4}[1-9]['||LASTDATA||']$'
        ) 
        
        , '1'
        , 'TRUE'
        , '0'
        , 'FALSE'
        ) JUMIN
        FROM ( 
SELECT 
        11 - MOD(
        MIN (DECODE(LEVELK , '1', NUM * 2)) 
       + MIN (DECODE(LEVELK , '2', NUM * 3)) 
       + MIN (DECODE(LEVELK , '3', NUM * 4)) 
       + MIN (DECODE(LEVELK , '4', NUM * 5)) 
       + MIN (DECODE(LEVELK , '5', NUM * 6)) 
       + MIN (DECODE(LEVELK , '6', NUM * 7)) 
       + MIN (DECODE(LEVELK , '7', NUM * 8)) 
       + MIN (DECODE(LEVELK , '8', NUM * 9)) 
       + MIN (DECODE(LEVELK , '9', NUM * 2)) 
       + MIN (DECODE(LEVELK , '10', NUM * 3)) 
       + MIN (DECODE(LEVELK , '11', NUM * 4)) 
       + MIN (DECODE(LEVELK , '12', NUM * 5))  
       , 11 ) LASTDATA
FROM
( SELECT SUBSTR(:ARG, LEVEL , 1) NUM
        , LEVEL LEVELK
        , 'ORION' GRP
        FROM DUAL
       CONNECT BY LEVEL <= LENGTH(:ARG)
)
GROUP BY GRP
)

 

 

주민등록번호 오라클 처리