교재 84, 85페이지 REPLACE 퀴즈 1 ~ 4번

--문제1

SELECT ENAME, REPLACE(ENAME, SUBSTR(ENAME, 2, 2), '--') "REPLACE"
FROM EMP
WHERE DEPTNO = 20;



--문제2

SELECT NAME, JUMIN, REPLACE(JUMIN, SUBSTR(JUMIN, 7, 13), '-/-/-/-') "REPLACE"
FROM STUDENT
WHERE DEPTNO1 = 101;



--문제3

SELECT NAME, TEL, REPLACE(TEL, SUBSTR(TEL, INSTR(TEL, ')') + 1, 3), '***') "REPLACE"
FROM STUDENT
WHERE DEPTNO1 = 102;



--문제4

SELECT NAME, TEL, REPLACE(TEL, SUBSTR(TEL, INSTR(TEL, '-') + 1, 4), '****') "REPLACE"
FROM STUDENT
WHERE DEPTNO1 = 101;

 

 

문제1

 

 

 

문제2

 

 

 

문제3

 

 

 

문제4