Oracle gets the first letter of Chinese characters ____oracle

 

CREATE OR REPLACE FUNCTION f_pinyin (p_name in VARCHAR2) return VARCHAR2 as V_compare VARCHAR2 (100);

     V_return VARCHAR2 (4000); FUNCTION F_nlssort (P_word in VARCHAR2) return VARCHAR2 as BEGIN return Nlssort (P_word, ' Nls_sort=schinese_pinyi
     N_m ');
    End;
     BEGIN for I in 1..NVL (LENGTH (P_name), 0) LOOP v_compare: = F_nlssort (SUBSTR (P_name, I, 1)); IF v_compare >= f_nlssort (' Acridine ') and V_compare <= f_nlssort (' 驁 ') THEN v_return: = V_return | |
     ' A '; elsif v_compare >= f_nlssort (' VIII ') and V_compare <= (' book ') f_nlssort THEN: = V_return | |
     ' B '; elsif v_compare >= f_nlssort (' Cha ') and V_compare <= (' wrong ') f_nlssort THEN: = V_return | |
     ' C '; elsif v_compare >= f_nlssort (' 咑 ') and V_compare <= (' F_nlssort ') 鵽 THEN: = V_return | |
     ' D '; elsif v_compare >= f_nlssort (' 妸 ') and V_compare <= (' F_nlssort ') 樲 THEN: = V_return | |
     ' E '; elsif v_compare >= F_nlsSORT (' hair ') and V_compare <= f_nlssort (' 猤 ') THEN v_return: = V_return | |
     ' F '; elsif v_compare >= f_nlssort (' there ') and V_compare <= (' F_nlssort ') hiker THEN: = V_return | |
     ' G '; elsif v_compare >= f_nlssort (' 妎 ') and V_compare <= (' F_nlssort ') 夻 THEN: = V_return | |
     ' H '; elsif v_compare >= f_nlssort (' no ') and V_compare <= (' F_nlssort ') 攈 THEN: = V_return | |
     ' J '; elsif v_compare >= f_nlssort (' ka ') and V_compare <= (' F_nlssort ') 穒 THEN: = V_return | |
     ' K '; elsif v_compare >= f_nlssort (' garbage ') and V_compare <= (' F_nlssort ') 擽 THEN: = V_return | |
     ' L '; elsif v_compare >= f_nlssort (' 嘸 ') and V_compare <= (' F_nlssort ') 椧 THEN: = V_return | |
     ' M '; elsif v_compare >= f_nlssort (' 拏 ') and V_compare <= (' f_nlssort ') malaria THEN: = V_return | |
     ' N '; elsif v_compare >= f_nlssort (' 筽 ') and V_compare <= (' F_nlssort ') 漚 THEN : = V_return | |
     ' O '; elsif v_compare >= f_nlssort (' 妑 ') and V_compare <= (' exposure ') f_nlssort THEN: = V_return | |
     ' P '; elsif v_compare >= f_nlssort (' VII ') and V_compare <= (' F_nlssort ') 裠 THEN: = V_return | |
     ' Q '; elsif v_compare >= f_nlssort (' Everybody ') and V_compare <= (' F_nlssort ') 鶸 THEN: = V_return | |
     ' R '; elsif v_compare >= f_nlssort (' sa ') and v_compare <= (' F_nlssort ') 蜶 THEN: = V_return | |
     ' S '; elsif v_compare >= f_nlssort (' 侤 ') and V_compare <= (' F_nlssort ') 籜 THEN: = V_return | |
     ' T '; elsif v_compare >= f_nlssort (' 屲 ') and V_compare <= (' F_nlssort ') 鶩 THEN: = V_return | |
     ' W '; elsif v_compare >= F_nlssort (' XI ') and V_compare <= (' F_nlssort ') 鑂 THEN: = V_return | |
     ' X '; elsif v_compare >= f_nlssort (' ya ') and V_compare <= (' f_nlssort ') rhythmic THEN: = V_return | |
     ' Y '; elsif v_compare >= f_nlssort (' 帀 ') AND v_compare <= f_nlssort (' out ') THEN v_return: = V_return | |
     ' Z ';
    End IF;
    End LOOP;
   return v_return;
End; --Use Pl/sql-->file-->new-->command window--> copy paste in---> Re-enter/Enter, you will be prompted to create success such as: Function created-
 This allows you to query the select * from Auth_User s where F_pinyin (s.name) like ' c% '