LTRIM, RTRIM, TRIM

LTRIM, RTRIM, TRIM 에 대해 알아보자(문자열 제거).

LTRIM : 왼쪽 잘라내기

RTRIM : 오른쪽 잘라내기

TRIM : 양쪽 잘라내기

예제

SELECT LTRIM('ABCDEFABC', 'ABC') AS RESULT FROM DUAL
 
SELECT RTRIM('ABCDEFABC', 'ABC') AS RESULT FROM DUAL
 
SELECT TRIM(' ABCDEFABC')  AS RESULT FROM DUAL -- 공백제거
SELECT TRIM(BOTH 'A' FROM 'ABCDEFABCA')  AS RESULT FROM DUAL -- 양쪽 A제거
SELECT TRIM(LEADING 'A' FROM 'ABCDEFABC')  AS RESULT FROM DUAL --왼쪽 A제거
SELECT TRIM(TRAILING 'C' FROM 'ABCDEFABC')  AS RESULT FROM DUAL --오른쪽 C제거