oracle 删除trigger 创建视图 导出表结构

1、删除trigger 

 

drop trigger tib_operationondata(trigger的名称);

 

2、创建视图

 

create view OLAP_SQAndNYERPDEPLOYSON
  (STATDATE,GUIKOUDEPID,OUTWAREHOUSEID,INWAREHOUSEID,BRIEFID,PROFESSIONALID,SPECIFYID,CASHBUDGETID,PRICE,AMOUNT,ISWORN,jine,sqspecifyid,sqamount,sqprice,sqjine)
as
select
 to_char(p.CREATEDATE,'yyyymmdd') as STATDATE,
 p.GUIKOUDEPARTMENTID as GUIKOUDEPID,
 p.OUTWAREHOUSEID,
 p.INWAREHOUSEID,
 p.BRIEFID
 p.PROFESSIONALID ,
 m.SPECIFYID,
 s.ID as CASHBUDGETID,
 m.PRICE,
 sum(m.AMOUNT) as AMOUNT,
 m.ISWORN,
 sum(m.PRICE*m.AMOUNT) as jine,
 fm.SPECIFYID as sqspecifyid,
 sum(fm.amount) as sqamount,
 fm.PRICE as sqprice,
 sum(fm.PRICE*fm.AMOUNT) as sqjine