오라클 문자 분리

SELECT SUBSTR(EMAIL, INSTR(EMAIL, '@',1,1) +1) AS LASTVAL,
                SUBSTR(EMAIL,0, INSTR(EMAIL, '@',1,1)-1) AS FIRSTVAL,
             EMAIL
    FROM 테이블명;