Oracle中有四种视图:
关系视图
内嵌视图
对象视图
物化视图
需要的表和数据信息:
create table employees(employee_id number primary key , first_name varchar2(4), last_name varchar2(4), province varchar2(10),city varchar2(10),salary number);
insert into employees values(1,'军','张','广州','深圳',3000);
insert into employees values(2,'新','刘','广东','深圳',4000);
insert into employees values(3,'凡','王','广西','桂林',3800);
insert into employees values(4,'峰','周','江苏','苏州',4000);
insert into employees values(5,'佳','