您应该结合使用SUBSTR和INSTR函数
select substr('A B C',0,instr('A B C',' ')) from dual -- AUNIOn ALLselect substr( 'A B C',instr('A B C',' ') , instr('A B C',' ',1,2)-1 ) from dual --BUNIOn ALLselect substr( 'A B C', instr('A B C',' ',1,2) , instr('A B C',' ') ) from dual -- C*用您的字符串替换ABC
