[Oracle] substr 함수

select substr(EAS220_DOC_NO,1,INSTR(EAS220_DOC_NO,'-',1,1))
from eas220tl
where EAS220_DOC_SEQ = 'AA08003201002231754040140'

 

예)  전산개발부-0808  -> 전산개발부-    요렇게 변경됨 ㅋㅋ