CREATE OR REPLACE FUNCTION BANK1CTR.FT_AML_T300ACCOUNTNUM(AccountNum IN Char)
RETURN varchar2
IS
  result_String  varchar2(30);
BEGIN
    result_String := '';
    select CASE WHEN length(trim(AccountNum)) between 14 and 15 then substr(AccountNum,1,6)||'-'||substr(AccountNum,7,2)||'-'||substr(AccountNum,9)
                ELSE trim(AccountNum) END 계좌번호
    into result_String
    from dual;
    RETURN(result_String);
END;
/


CREATE OR REPLACE FUNCTION BANK1CTR.FT_AML_T300CUSTNUM(CustNum IN Char)
RETURN varchar2
IS
  result_String  varchar2(30);
BEGIN
    result_String := '';
    select CASE WHEN length(trim(CustNum)) = 13 then substr(CustNum,1,6)||'-'||substr(CustNum,7)
                WHEN length(trim(CustNum)) = 10 then substr(CustNum,1,3)||'-'||substr(CustNum,4,2)||'-'||substr(CustNum,6)
                ELSE trim(CustNum) END 고객번호
    into result_String
    from TSAMLCM20
    where 영업년월일1 = '20050101';
    RETURN(result_String);
END;
/


GRANT EXECUTE ON  BANK1CTR.FT_AML_T300CUSTNUM TO AML000;

GRANT EXECUTE ON  BANK1CTR.FT_AML_T300ACCOUNTNUM TO AML000;