– 创建一个视图 ,如果有就替换,如果没有就创建
create or replace view emp_yfb as
select d.*,a.dname,a.loc from dept a ,emp d where a.deptno = d.deptno;
– 查询试图
select * from emp_yfb;
– 创建一个视图 ,如果有就替换,如果没有就创建
create or replace view emp_yfb as
select d.*,a.dname,a.loc from dept a ,emp d where a.deptno = d.deptno;
– 查询试图
select * from emp_yfb;