오라클에서 특정 문자의 개수 구하기

SELECT length(DATA) - length(replace(DATA, '/', '')) CHAR_COUNT
FROM (
    SELECT '/abcde/ffdd/acd/1234/5432' DATA
    FROM dual
);

SELECT length(DATA) - length(replace(DATA, '/', '')) CHAR_COUNT

FROM (

SELECT '/abcde/ffdd/acd/1234/5432' DATA

FROM dual

);

결과 : 5

오라클에서 마지막 / 이후의 문자열만 추출하기

SELECT reverse(substr(reverse(DATA), 1, instr(reverse(DATA), '/') - 1))
FROM (
    SELECT '/abcde/ffdd/acd/1234/5432.jsp' DATA
    FROM dual
);

SELECT reverse(substr(reverse(DATA), 1, instr(reverse(DATA), '/') - 1))

FROM (

SELECT '/abcde/ffdd/acd/1234/5432.jsp' DATA

FROM dual

);

결과 : 5432.jsp

Apollo89.com