视图: view
虚拟的表格,不会占用磁盘空间,是一个sql语句运行的结果。
创建的语法:
create view 视图名字 as select 查询语句;
create view sal3 as
select ename,sal,deptno from
(select a.*,rownum r from
(select * from emp_4 order by sal desc) a) b
where r<=3;
select * from sal3;
所以 sal3 就是上面的那个select语句。