instr(string,'substring,position,ocurrence) select substr('索尼-爱立信-华为',instr('索尼-爱立信-华为','-',-1,1)+1) from dual