|
ACS3 Data Model |
||||||||||||
|
Name | Data Type | Default Value | In/Out |
---|---|---|---|
LETTER_NO | INTEGER(38.0) | IN |
Source |
---|
1: function mobin_number_to_letter (letter_no IN integer) 2: return varchar2 3: IS 4: letter varchar(1); 5: BEGIN 6: select decode(letter_no, '1', 'A', '2', 'B', '3', 'C', 7: '4', 'D', '5', 'E', '6', 'F', 8: '7', 'G', '8', 'H', '9', 'I', 9: '10', 'J', '11', 'K', '12', 'L', 10: '13', 'M', '14', 'N', '15', 'O', 11: '16', 'P', '17', 'Q', '18', 'R', 12: '19', 'S', '20', 'T', '21', 'U', 13: '22', 'V', '23', 'W', '24', 'X', 14: '25', 'Y', 'Z') into letter 15: from dual; 16: return letter; 17: 18: END; |