REPLACE 퀴즈

1번

-- REPLACE 퀴즈 1
SELECT ename, REPLACE(ename, substr(ename, 2, 2), '--') REPLACE
FROM emp;

 

2번

-- REPLACE 퀴즈 2
SELECT name, jumin, REPLACE(jumin, substr(jumin, 7, 7), '-/-/-/-') REPLACE
FROM student
WHERE deptno1 = 101;

 

3번

-- REPLACE 퀴즈 3
SELECT name, tel, REPLACE(tel, substr(tel, instr(tel, ')')+1, instr(tel, '-')-instr(tel, ')')-1), '***') REPLACE
FROM student
WHERE deptno1 = 102;

 

4번

-- REPLACE 퀴즈 4
SELECT name, tel, REPLACE(tel, substr(tel, instr(tel, '-')+1, 4), '****') REPLACE
FROM student
WHERE deptno1 = 101;