Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

MOBIN_NUMBER_TO_LETTER

Arguments:

NameData TypeDefault ValueIn/Out
LETTER_NOINTEGER(38.0) IN

Returns:

VARCHAR2

Source

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;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002