실습문제_2장-1.pdf

SELECT name,substr(jumin,3,4)as "생년월일"
    from student
    where deptno1=101;

실습문제_2장-2.pdf

SELECT NAME, TEL, INSTR(TEL,')') AS INSTR
    FROM STUDENT
    WHERE DEPTNO1=201;

실습문제_2장-3.pdf

SELECT NAME, TEL, INSTR(TEL,8,1,2) AS INSTR
    FROM STUDENT
    WHERE DEPTNO1=101;

실습문제_2장-4.pdf

SELECT NAME, TEL, SUBSTR(TEL,1,INSTR(TEL,')')-1) AS "AREA CODE"
    FROM STUDENT
    WHERE DEPTNO1=201;