|
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;
|