[오늘쿼리] REPLACE

SELECT ENAME, REPLACE(SAL,0,'*')
	FROM EMP;

결과

ENAME | REPLACE(SAL,0,'*')
KING | 5**
BLAKE | 285

SELECT ENAME, REGEXP_REPLACE(SAL, '[0-3]', '*') AS SALARY
	FROM EMP;

결과

ENAME | SALARY
KING | 5***
BLAKE | 85*

• REGEXP_REPLACE 는 정규식 적용됨