plsql - Oracle PL/SQL get the first letter from the name(HUN) -

plsql - Oracle PL/SQL get the first letter from the name(HUN) -

the question sounds easy because need substring (name,1,1). in hungarian language there many letter wich contains multicharacter. eg : cs,dz,dzs,ly,ny,sz,ty,zs

if v_type='by_name' select distinct name v_result my_table instr(_start_letters_,substr(upper(v_name),1,1))>0 , zipcode = v_act_zipcode; homecoming v_result;

and table eg:

zipcode name _start_letters 1234 ryan a,b,c 1234 bryan cs,d

and if want name csanád need cs not first char c-> becuase multirow exception.

do have anysuggestion utilize first lettor? or have write huge if-else/case construction create code awful , impenetrable.

thanks

i think straight-forward solution write stored function extracts first letter:

create function hun_first_letter(name in varchar2) homecoming varchar2 begin if substr(upper(name),1,3) in ('dzs') homecoming substr(name,1,3); elsif substr(upper(name),1,2) in ('cs','dz','ly','ny','sz','ty','zs','gy') homecoming substr(name,1,2); else homecoming substr(name,1,1); end if; end;

oracle plsql alphabet