Oracle improves the conversion of Arabic numerals into Chinese numerals

　　This blog is their own in the study and work on the way to accumulate and summarize.

Convert Arabic numerals to Chinese characters, method custom function
　　

　　

Create or Replace function Formate (valinchNumber )returnVarchar2 isRes VARCHAR2 (6); BeginifVal=1Then res:='a'; Elsif Val=2Then res:='two'; Elsif Val=3Then res:='three'; Elsif Val=4Then res:='Four'; Elsif Val=5Then res:='Five'; Elsif Val=6Then res:='Six'; Elsif Val=7Then res:='Seven'; Elsif Val=8Then res:='Eight'; Elsif Val=9Then res:='Nine'; Elsif Val=TenThen res:='10'; Elsif Val= OneThen res:='11'; Elsif Val= AThen res:='12'; Elsif Val= -Then res:='13'; Elsif Val= -Then res:='14'; Elsif Val= theThen res:='15'; Elsif Val= -Then res:='16'; Elsif Val= -Then res:='17'; Elsif Val= -Then res:='18'; Elsif Val= -Then res:='19'; Elsif Val= -Then res:='20'; Elsif Val= -Then res:='21'; Elsif Val= -Then res:='22'; Elsif Val= -Then res:='23'; Elsif Val= -Then res:='24'; Elsif Val= -Then res:='25'; Elsif Val= -Then res:='26'; Elsif Val= -Then res:='27'; Elsif Val= -Then res:='28'; Elsif Val= -Then res:='29'; Elsif Val= -Then res:='30'; Elsif Val= -Then res:='31'; Elsif Val= -Then res:='32'; Elsif Val= -Then res:='33'; Elsif Val= -Then res:='34'; Elsif Val= -Then res:='35'; Elsif Val= -Then res:='36'; Elsif Val= -Then res:='37'; Elsif Val= -Then res:='38'; Elsif Val= -Then res:='39'; Elsif Val= -Then res:='40'; Elsif Val= -Then res:='41'; Elsif Val= -Then res:='42'; ElseRes:="'; Endif; returnRes;end;

If there is an extension, stack the elsif.

Oracle improves the conversion of Arabic numerals into Chinese numerals