create or replace view vw_bq_brldtj as
select ID0000,' 合 计'BMMC00,9999 BMBH00,sum(to_number(TEMP01)) TEMP01,
       sum(to_number(TEMP02)) TEMP02,sum(to_number(TEMP03)) TEMP03,
       sum(to_number(TEMP04)) TEMP04,sum(to_number(TEMP05)) TEMP05,
       sum(to_number(Temp06)) TEMP06,sum(to_number(TEMP07)) TEMP07,
       sum(to_number(TEMP08)) TEMP08,sum(to_number(TEMP09)) TEMP09,
       sum(to_number(TEMP10)) TEMP10,sum(to_number(TEMP11)) TEMP11,
       sum(to_number(TEMP12)) TEMP12,sum(to_number(TEMP13)) TEMP13,
       sum(to_number(TEMP14)) TEMP14,
       ' '"start",' '"Stop"
from BQ_ZHTJ00_TEMP00 where FLAG00='BQ_BRLDTJ' GROUP BY ID0000
union all
select ID0000,BMMC00,BMBH00,to_number(TEMP01)TEMP01,
       to_number(TEMP02)TEMP02,to_number(TEMP03) TEMP03,
       to_number(TEMP04)TEMP04,to_number(TEMP05)TEMP05,
       to_number(TEMP06)TEMP06,to_number(TEMP07)TEMP07,
       to_number(TEMP08)TEMP08,to_number(TEMP09)TEMP09,
       to_number(TEMP10)TEMP10,to_number(TEMP11)TEMP11,
       to_number(TEMP12)TEMP12,to_number(TEMP13)TEMP13,
       to_number(TEMP14)TEMP14,
       startd||startt "start",stopda||stopti "Stop"
from BQ_ZHTJ00_TEMP00 where FLAG00='BQ_BRLDTJ';