[ORACLE] 문자 처리함수- 문자열 치환 REPLACE

SELECT S_NAME, REPLACE(S_NAME, '정', '김') "정->김" FROM STUDENT ORDER BY S_NAME;