-- 질문을 잘못봐서 수정했습니다. WITH T AS ( SELECT ' AB' ID FROM DUAL UNION ALL SELECT 'C D ' ID FROM DUAL UNION ALL SELECT 'EF ' ID FROM DUAL UNION ALL SELECT 'TT ' ID FROM DUAL ) --SELECT ID -- , '/' || ID || '/' -- , LENGTHB(ID) ID_CNT1 -- , LENGTHB(TRIM(ID)) ID_CNT2 -- FROM T -- WHERE LENGTHB(ID) != LENGTHB(TRIM(ID)) SELECT ID , '/' || ID || '/' , SUBSTR(ID,-1,1) ID_2 FROM T WHERE SUBSTR(ID,-1,1) = ' '