오라클 SQL Quiz 2

※ table은 오라클에서 기본으로 제공하는 EMP테이블을 이용하며 아래쿼리 문제의 출력결과를 쓰시오.

 

 

1.select upper('webprogram') from dual;

2. select round(sal,-2) from emp;

               

3. select mod(100+10,5) from dual;

4.select substr('webprogram class',instr('welcome to Oracle 10g','o'),3) from dual;

5. select length(ltrim('aaaoracle 10gaaa','a')) f개m dual;

6.select ename from emp where substr(hiredate,1,2)=87;

 

7. select last_day(sysdate) from dual;

8. select ename,deptno,decode(deptno, 10 , '서울',20,'대전',30,'대구',40,'부산') dname from emp;

9. 1) select avg(nvl(comm,0)) from emp;

    2) select avg(comm) from emp;

10. select ename,to_char(sal,'L999,999') from emp;