create or replace view vw_bq_brldtj as
select ' 合 计' 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,
       ' '"start",' '"Stop"
from bm_zhtj00_temp00 where flag00='BQ_BRLDTJ'
union all
select 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,
       startd||startt "start",stopda||stopti "Stop"
from bm_zhtj00_temp00 where flag00='BQ_BRLDTJ';