oracle 11G) SQL 데이터처리 부문 - 연습문제 실습 풀이

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;