이유없음

-- ic.bat ----------------------------------

set path=D:\ora\instantclient-11.1
sqlplus hr30/hr30@172.16.14.1:1521/orcl

--------------------------------------------

# 1-12

select empno, ename, sal, comm, sal*12+nvl(comm, 0)
from emp;

# 1-14

select empno, ename, sal, comm,
       sal*12+nvl(comm, 0)    ann_sal,
       sal*12+nvl(comm, 0) as ann_sal,
       sal*12+nvl(comm, 0)   "$Ann Sal"
from emp;

# 1-16, 17

select empno, ename, sal, comm, 'ABC', 2000
from emp;

select empno, ename, ' is a ', job, sal, comm
from emp;

select empno, ename||' is a '||job as sawon, sal, comm
from emp;

select empno, ename, substr(ename, 1, 1) as part1, substr(ename, 2

) as part2
from emp;

select empno, ename, length(ename)
from emp;

-- 9i 까지
select  ename|| ' ''s house is bigger than Tom'' s'
from emp;

-- 10g 이후
select ename|| q' [ 's house is bigger than Tom's] '
select ename|| q' ! 's house is bigger than Tom's! '
select ename|| q' X 's house is bigger than Tom'sX '
from emp;

select unique job
from emp;

select DISTINCT job
from emp;

select DISTINCT deptno, job   /* 뒤에 나오는 모든 열에 적용되어 영향을 준다. */
from emp;