주민등록번호 오라클 검사 처리
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(LEVEL..
프로그래밍/DB
2019. 9. 10. 16:04