oracle学习16-命令学习4

16 create view V
as
select name||' '||sal as data
from student --建立一个视图
select * from V--查询这个视图
17处理数据空值
select xh
from student order by 1 desc—空值排列
18 select xh
from student order by 1 desc nulls last--将空值置于最后排序
19 select id,xh,sal,
case when xh is null then 0 else 1 end as is_null
from student—查找为空的值并建立一个表查看
20根据数据项的值进行排序
select id,xh,sal,depo from student
order by case when depo='工程部' then xh else sal end --有工程部的按照xh排序否则按照工资排序