실습문제_4-1.pdf

실습문제_4-2.pdf

select name,id,hpage from professor where deptno=102 and hpage is not null;

실습문제_4-3.pdf

select name, pay, hiredate from professor where pay>=300 and pay<=500;

실습문제_4-4.pdf

select name,id,position from professor where id like '%er';

실습문제_4-5.pdf

select profno, name, bonus, pay, deptno
,pay*12+bonus"총 연봉" 
from professor 
where bonus is not null
order by deptno desc, (pay*12+bonus) asc;

실습문제_4-6.pdf

select name,pay,bonus
from professor
where (bonus is null and pay>= 300)
or (pay >= 500);

실습문제_DECODE-1.pdf

select name
    ,tel
    ,decode((instr(tel,'-')-instr(tel,')')),5,
    replace(tel,substr(tel,instr(tel,')')+1,4),'****'),
    replace(tel,substr(tel,instr(tel,')')+1,3),'***')) "REPLACE"
    FROM EMP2;