- 001
- 002
- 003
- 004
- 005
- 006
- 007
- 008
- 009
- 010
- 011
- 012
- 013
- 014
- 015
- 016
- 017
- 018
- 019
- 020
- 021
- 022
- 023
- 024
- 025
- 026
- 027
- 028
- 029
- 030
- 031
- 032
- 033
- 034
- 035
- 036
- 037
- 038
- 039
- 040
- 041
- 042
- 043
- 044
- 045
- 046
- 047
- 048
- 049
- 050
- 051
- 052
- 053
- 054
- 055
- 056
- 057
- 058
- 059
- 060
- 061
- 062
- 063
- 064
- 065
- 066
- 067
- 068
- 069
- 070
- 071
- 072
- 073
- 074
- 075
- 076
- 077
- 078
- 079
- 080
- 081
- 082
- 083
- 084
- 085
- 086
- 087
- 088
- 089
- 090
- 091
- 092
- 093
- 094
- 095
- 096
- 097
- 098
- 099
- 100
FUNCTION traslate2eng (
as_str_i IN VARCHAR2
) RETURN VARCHAR2
IS
ls_out_str VARCHAR2(2000);
lb_flag BOOLEAN;
TYPE r_tran_symbols IS RECORD (
ukr_char VARCHAR2(1)
, eng_char VARCHAR2(4)
);
TYPE t_tran_symbols IS TABLE OF r_tran_symbols INDEX BY BINARY_INTEGER;
lt_tran_symbols t_tran_symbols;
BEGIN
lt_tran_symbols.DELETE;
lt_tran_symbols(1).eng_char := 'A';
lt_tran_symbols(1).ukr_char := 'А';
lt_tran_symbols(2).eng_char := 'B';
lt_tran_symbols(2).ukr_char := 'Б';
lt_tran_symbols(3).eng_char := 'V';
lt_tran_symbols(3).ukr_char := 'В';
lt_tran_symbols(4).eng_char := 'G';
lt_tran_symbols(4).ukr_char := 'Г';
lt_tran_symbols(5).eng_char := 'H';
lt_tran_symbols(5).ukr_char := CHR(165);--'_';
lt_tran_symbols(6).eng_char := 'D';
lt_tran_symbols(6).ukr_char := 'Д';
lt_tran_symbols(7).eng_char := 'E';
lt_tran_symbols(7).ukr_char := 'Е';
lt_tran_symbols(8).eng_char := 'YE';
lt_tran_symbols(8).ukr_char := 'Є';
lt_tran_symbols(9).eng_char := 'ZH';
lt_tran_symbols(9).ukr_char := 'Ж';
lt_tran_symbols(10).eng_char := 'Z';
lt_tran_symbols(10).ukr_char := 'З';
lt_tran_symbols(11).eng_char := 'Y';
lt_tran_symbols(11).ukr_char := 'И';
lt_tran_symbols(12).eng_char := 'I';
lt_tran_symbols(12).ukr_char := '_';
lt_tran_symbols(13).eng_char := 'YI';
lt_tran_symbols(13).ukr_char := 'Ї';
lt_tran_symbols(14).eng_char := 'Y';
lt_tran_symbols(14).ukr_char := 'Й';
lt_tran_symbols(15).eng_char := 'K';
lt_tran_symbols(15).ukr_char := 'К';
lt_tran_symbols(16).eng_char := 'L';
lt_tran_symbols(16).ukr_char := 'Л';
lt_tran_symbols(17).eng_char := 'M';
lt_tran_symbols(17).ukr_char := 'М';
lt_tran_symbols(18).eng_char := 'N';
lt_tran_symbols(18).ukr_char := 'Н';
lt_tran_symbols(19).eng_char := 'O';
lt_tran_symbols(19).ukr_char := 'О';
lt_tran_symbols(20).eng_char := 'P';
lt_tran_symbols(20).ukr_char := 'П';
lt_tran_symbols(21).eng_char := 'R';
lt_tran_symbols(21).ukr_char := 'Р';
lt_tran_symbols(22).eng_char := 'S';
lt_tran_symbols(22).ukr_char := 'С';
lt_tran_symbols(23).eng_char := 'T';
lt_tran_symbols(23).ukr_char := 'Т';
lt_tran_symbols(24).eng_char := 'U';
lt_tran_symbols(24).ukr_char := 'У';
lt_tran_symbols(25).eng_char := 'F';
lt_tran_symbols(25).ukr_char := 'Ф';
lt_tran_symbols(26).eng_char := 'KH';
lt_tran_symbols(26).ukr_char := 'Х';
lt_tran_symbols(27).eng_char := 'TS';
lt_tran_symbols(27).ukr_char := 'Ц';
lt_tran_symbols(28).eng_char := 'CH';
lt_tran_symbols(28).ukr_char := 'Ч';
lt_tran_symbols(29).eng_char := 'SH';
lt_tran_symbols(29).ukr_char := 'Ш';