oracle 11G) SQL 데이터처리 부문 - 연습문제 풀이
select substr(hiredate,1,2) 년도,
substr(hiredate,4,2)달
from employee;
select * from employee
where substr(hiredate,4,2)='04';
select * from employee
where MOD(eno,2) = 0;
select hiredate,
to_char(hiredate, 'yy/mon/dy')
from employee;
select trunc(sysdate-to_date('2011/01/01','yyyy/mm/dd'))
from dual;
--decode(표현식, 조건1, 결과1,
-- 조건2, 결과2,
-- 기본결과n
-- )
select eno, ename, job, salary,
decode(job,'analyst',salary+200,
'salesman',salary+180,
'manager',salary+150,
'clerk',salary+100,
salary) as update_salary
from employee;
댓글