oracle视图

 

oracle视图实例：

 

create or replace view v_lpromis_ysgl_ndysyqyxm(ID,名称,类型,客户名称,计划开始,计划结束,总额) as 
select t.项目ID,t.项目名称,t.项目类型,t.客户,t.计划开始,t.计划结束,t.项目总额
  from (select pt.xmid 项目ID,pt.xmmc 项目名称,mast.dmnr 项目类型,ct.KHQC 客户,pt.jhks 计划开始,pt.jhjs 计划结束,pt.xmzje 项目总额,
               rank() over(partition by pt.xmid order by pt.xmbbh desc) rn
          from T_LPROMIS_XMGL_GBBXMXX pt,T_LPROMIS_YXGL_KHXX ct,t_lpromis_base_mast mast 
         where pt.xmid in (select ct.xmid from T_LPROMIS_YXGL_HTXX ct)
           and mast.DMBH = pt.CWLX
           and pt.khid = ct.id
           and extract(year from pt.xmjhjssj) > extract(year from sysdate)) t
 where t.rn = 1
 with read only;