이자다의 기록

--문제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(..

1. LAPD SELECT LPAD(ENAME, 9, '12345') "LPAD" FROM emp WHERE DEPTNO = 10; 2. RAPD SELECT RPAD(ENAME, 9, SUBSTR('123456789', LENGTHB(ENAME) + 1, 9)) "RPAD" FROM emp WHERE DEPTNO = 10;