创建视图 例子

create or replace view v_td_allgg as
select id,boutname,startdate,enddate,type,hydm from (
      select zb.ggid as id, zb.promc  as boutname, zb.gmbsjs as startdate,zb.gmbsks  as enddate,1 as type,null as hydm from  td_zbgg zb where zb.ggzt=2
       union all
      select qi.fphm as id ,qi.title  as boutname ,qi.date1 as startdate ,qi.date0 as enddate,2 as type,qi.hydms as hydm from  Td_Query_Info qi  where qi.STATUS =100 and qi.flag06 = 1
       union all
      select td.boutid as id, td.boutname ,td.startdate ,td.enddate , 3 as type,null as hydm from  TD_TD_BOUT td where td.STATUS in ('30','40')
       union all select ac.boutid as id, ac.boutname ,ac.startdate ,ac.enddate, 4 as type,null as hydm  from TD_AC_BOUT ac where ac.STATUS in ('30','40')
      ) order by startdate desc;