个人学习讲解

1.nvl的用法

select  empno,ename,job,sal,nvl(comm,0) from emp where deptno=10;

2.nvl2的用法

select  empno,ename,job,sal,nvl2(comm,sal+comm,sal) from emp where deptno=10;

3.i 追加行

i and ename like '%e%'

4.在缓冲区放到最前

0 create table temp as select * from emp;

5.edit,@ ,@@,a,i,save,spool命令

6.ttitle,btitle的用法

 1.ttitle 'report home'

 2.btitle 'report end'

 3. select * from dept;

 

7.termout,timing,time