检索dept中所有的记录,并按部门名称排序。
create or replace view v1 as
select * from univ.dept order by dname;
列出工资(SAL)在15000到25000之间的所有员工的ENAME,SAL,并按ENAME排序。
create view V2 as
select ename,sal
from univ.emp
where sal between 15000 and 25000
order by ename;
显示DEPT表中的部门编号和部门名称,并按部门名称排序。
create or replace view V3 as
select deptno,dname
from univ.dept
order by dname;
显示所有不同的工作类型,并降序排序。
create or replace view v4 as
select distinct job from univ.emp order by job desc;
列出没有提成(comm)的所有职工的姓名与工资,并按姓名排序。
create view V5 as
select ename,sal
from univ.emp
where comm is null
order by ename;
列出部门编号是20,工作是“clerk”(办事员)的职工信息,并按姓名排序。
create view v6 as
select *
from univ.emp
where (job='clerk'and deptno=20)order by ename;
显示姓名中包含AR或IN的职工姓名,并按姓名排序。
create view v7 as
select ename
from univ.emp
where (ename like'%AR%' or ename like'%IN%')
order by ename;
显示姓名中包含AR和IN的职工姓名,并按姓名排序。 </