jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/other/8.view.sql

create materialized view GK_SHARE_JSJY_HJ_FHLTTL_MV
refresh force on demand
start with to_date('09-01-2017 23:00:00', 'dd-mm-yyyy hh24:mi:ss') next to_date(concat(to_char(sysdate+1,'dd-mm-yyyy'),' 23:00:00'),'dd-mm-yyyy hh24:mi:ss') 
as
select
  substr(a.datatime,0,4)||'-'||substr(a.datatime,8,2) as tj_month,
nvl(sum(gk03010202000000000000000000),0)as   gk03010202000000000000000000,
nvl(sum(gk03010202000000000000010000),0)as   gk03010202000000000000010000,
nvl(sum(gk03010202000000000000010100),0)as   gk03010202000000000000010100,
nvl(sum(gk03010202000000020100000000),0)as   gk03010202000000020100000000,
nvl(sum(gk03010202000000020110000000),0)as   gk03010202000000020110000000,
nvl(sum(gk03010202000000020200000000),0)as   gk03010202000000020200000000,
nvl(sum(gk03010202000000020210000000),0)as   gk03010202000000020210000000,
nvl(sum(gk03010202000000020220000000),0)as   gk03010202000000020220000000,
nvl(sum(gk03010202000000020230000000),0)as   gk03010202000000020230000000,
nvl(sum(gk03010202000000020300000000),0)as   gk03010202000000020300000000,
nvl(sum(gk03010202000000020310000000),0)as   gk03010202000000020310000000,
nvl(sum(gk03010202000000020400000000),0)as   gk03010202000000020400000000,
nvl(sum(gk03010202000000020410000000),0)as   gk03010202000000020410000000,
nvl(sum(gk03010202000000020420000000),0)as   gk03010202000000020420000000,
nvl(sum(gk03010202000000020500000000),0)as   gk03010202000000020500000000,
nvl(sum(gk03010202000000020510000000),0)as   gk03010202000000020510000000,
nvl(sum(gk03010202000000020600000000),0)as   gk03010202000000020600000000,
nvl(sum(gk03010202000000020700000000),0)as   gk03010202000000020700000000,
nvl(sum(gk03010202000000020710000000),0)as   gk03010202000000020710000000,
nvl(sum(gk03010202000000020800000000),0)as   gk03010202000000020800000000,
nvl(sum(gk03010202000000020810000000),0)as   gk03010202000000020810000000,
nvl(sum(gk03010202000000020900000000),0)as   gk03010202000000020900000000,
nvl(sum(gk03010202000000021000000000),0)as   gk03010202000000021000000000,
nvl(sum(gk03010202000000021100000000),0)as   gk03010202000000021100000000,
nvl(sum(gk03010202000000021110000000),0)as   gk03010202000000021110000000,
nvl(sum(gk03010202000000021120000000),0)as   gk03010202000000021120000000,
nvl(sum(gk03010202000000021130000000),0)as   gk03010202000000021130000000,
nvl(sum(gk03010202000000021140000000),0)as   gk03010202000000021140000000,
nvl(sum(gk03010202000000021200000000),0)as   gk03010202000000021200000000,
nvl(sum(gk03010202000000021300000000),0)as   gk03010202000000021300000000,
nvl(sum(gk03010202000000021310000000),0)as   gk03010202000000021310000000,
nvl(sum(gk03010202000000021320000000),0)as   gk03010202000000021320000000,
nvl(sum(gk03010202000000021400000000),0)as   gk03010202000000021400000000,
nvl(sum(gk03010202000000021500000000),0)as   gk03010202000000021500000000,
nvl(sum(gk03010202000000021510000000),0)as   gk03010202000000021510000000,
nvl(sum(gk03010202000000021520000000),0)as   gk03010202000000021520000000,
nvl(sum(gk03010202000000021530000000),0)as   gk03010202000000021530000000,
nvl(sum(gk03010202000000021600000000),0)as   gk03010202000000021600000000,
nvl(sum(gk03010202000000021610000000),0)as   gk03010202000000021610000000,
nvl(sum(gk03010202000000021700000000),0)as   gk03010202000000021700000000,
nvl(sum(gk03010202000000021710000000),0)as   gk03010202000000021710000000,
nvl(sum(gk03010202000000021720000000),0)as   gk03010202000000021720000000,
nvl(sum(gk03010202000000021730000000),0)as   gk03010202000000021730000000,
nvl(sum(gk03010202000001000000000000),0)as   gk03010202000001000000000000,
nvl(sum(gk03010202000001000000010000),0)as   gk03010202000001000000010000,
nvl(sum(gk03010202000001000000010100),0)as   gk03010202000001000000010100,
nvl(sum(gk03010202000001020100000000),0)as   gk03010202000001020100000000,
nvl(sum(gk03010202000001020110000000),0)as   gk03010202000001020110000000,
nvl(sum(gk03010202000001020200000000),0)as   gk03010202000001020200000000,
nvl(sum(gk03010202000001020210000000),0)as   gk03010202000001020210000000,
nvl(sum(gk03010202000001020220000000),0)as   gk03010202000001020220000000,
nvl(sum(gk03010202000001020230000000),0)as   gk03010202000001020230000000,
nvl(sum(gk03010202000001020300000000),0)as   gk03010202000001020300000000,
nvl(sum(gk03010202000001020310000000),0)as   gk03010202000001020310000000,
nvl(sum(gk03010202000001020400000000),0)as   gk03010202000001020400000000,
nvl(sum(gk03010202000001020410000000),0)as   gk03010202000001020410000000,
nvl(sum(gk03010202000001020420000000),0)as   gk03010202000001020420000000,
nvl(sum(gk03010202000001020500000000),0)as   gk03010202000001020500000000,
nvl(sum(gk03010202000001020510000000),0)as   gk03010202000001020510000000,
nvl(sum(gk03010202000001020600000000),0)as   gk03010202000001020600000000,
nvl(sum(gk03010202000001020700000000),0)as   gk03010202000001020700000000,
nvl(sum(gk03010202000001020710000000),0)as   gk03010202000001020710000000,
nvl(sum(gk03010202000001020800000000),0)as   gk03010202000001020800000000,
nvl(sum(gk03010202000001020810000000),0)as   gk03010202000001020810000000,
nvl(sum(gk03010202000001020900000000),0)as   gk03010202000001020900000000,
nvl(sum(gk03010202000001021000000000),0)as   gk03010202000001021000000000,
nvl(sum(gk03010202000001021100000000),0)as   gk03010202000001021100000000,
nvl(sum(gk03010202000001021110000000),0)as   gk03010202000001021110000000,
nvl(sum(gk03010202000001021120000000),0)as   gk03010202000001021120000000,
nvl(sum(gk03010202000001021130000000),0)as   gk03010202000001021130000000,
nvl(sum(gk03010202000001021140000000),0)as   gk03010202000001021140000000,
nvl(sum(gk03010202000001021200000000),0)as   gk03010202000001021200000000,
nvl(sum(gk03010202000001021300000000),0)as   gk03010202000001021300000000,
nvl(sum(gk03010202000001021310000000),0)as   gk03010202000001021310000000,
nvl(sum(gk03010202000001021320000000),0)as   gk03010202000001021320000000,
nvl(sum(gk03010202000001021400000000),0)as   gk03010202000001021400000000,
nvl(sum(gk03010202000001021500000000),0)as   gk03010202000001021500000000,
nvl(sum(gk03010202000001021510000000),0)as   gk03010202000001021510000000,
nvl(sum(gk03010202000001021520000000),0)as   gk03010202000001021520000000,
nvl(sum(gk03010202000001021530000000),0)as   gk03010202000001021530000000,
nvl(sum(gk03010202000001021600000000),0)as   gk03010202000001021600000000,
nvl(sum(gk03010202000001021610000000),0)as   gk03010202000001021610000000,
nvl(sum(gk03010202000001021700000000),0)as   gk03010202000001021700000000,
nvl(sum(gk03010202000001021710000000),0)as   gk03010202000001021710000000,
nvl(sum(gk03010202000001021720000000),0)as   gk03010202000001021720000000,
nvl(sum(gk03010202000001021730000000),0)as   gk03010202000001021730000000,
nvl(sum(gk03010202000002000000000000),0)as   gk03010202000002000000000000,
nvl(sum(gk03010202000002000000010000),0)as   gk03010202000002000000010000,
nvl(sum(gk03010202000002000000010100),0)as   gk03010202000002000000010100,
nvl(sum(gk03010202000002020100000000),0)as   gk03010202000002020100000000,
nvl(sum(gk03010202000002020110000000),0)as   gk03010202000002020110000000,
nvl(sum(gk03010202000002020200000000),0)as   gk03010202000002020200000000,
nvl(sum(gk03010202000002020210000000),0)as   gk03010202000002020210000000,
nvl(sum(gk03010202000002020220000000),0)as   gk03010202000002020220000000,
nvl(sum(gk03010202000002020230000000),0)as   gk03010202000002020230000000,
nvl(sum(gk03010202000002020300000000),0)as   gk03010202000002020300000000,
nvl(sum(gk03010202000002020310000000),0)as   gk03010202000002020310000000,
nvl(sum(gk03010202000002020400000000),0)as   gk03010202000002020400000000,
nvl(sum(gk03010202000002020410000000),0)as   gk03010202000002020410000000,
nvl(sum(gk03010202000002020420000000),0)as   gk03010202000002020420000000,
nvl(sum(gk03010202000002020500000000),0)as   gk03010202000002020500000000,
nvl(sum(gk03010202000002020510000000),0)as   gk03010202000002020510000000,
nvl(sum(gk03010202000002020600000000),0)as   gk03010202000002020600000000,
nvl(sum(gk03010202000002020700000000),0)as   gk03010202000002020700000000,
nvl(sum(gk03010202000002020710000000),0)as   gk03010202000002020710000000,
nvl(sum(gk03010202000002020800000000),0)as   gk03010202000002020800000000,
nvl(sum(gk03010202000002020810000000),0)as   gk03010202000002020810000000,
nvl(sum(gk03010202000002020900000000),0)as   gk03010202000002020900000000,
nvl(sum(gk03010202000002021000000000),0)as   gk03010202000002021000000000,
nvl(sum(gk03010202000002021100000000),0)as   gk03010202000002021100000000,
nvl(sum(gk03010202000002021110000000),0)as   gk03010202000002021110000000,
nvl(sum(gk03010202000002021120000000),0)as   gk03010202000002021120000000,
nvl(sum(gk03010202000002021130000000),0)as   gk03010202000002021130000000,
nvl(sum(gk03010202000002021140000000),0)as   gk03010202000002021140000000,
nvl(sum(gk03010202000002021200000000),0)as   gk03010202000002021200000000,
nvl(sum(gk03010202000002021300000000),0)as   gk03010202000002021300000000,
nvl(sum(gk03010202000002021310000000),0)as   gk03010202000002021310000000,
nvl(sum(gk03010202000002021320000000),0)as   gk03010202000002021320000000,
nvl(sum(gk03010202000002021400000000),0)as   gk03010202000002021400000000,
nvl(sum(gk03010202000002021500000000),0)as   gk03010202000002021500000000,
nvl(sum(gk03010202000002021510000000),0)as   gk03010202000002021510000000,
nvl(sum(gk03010202000002021520000000),0)as   gk03010202000002021520000000,
nvl(sum(gk03010202000002021530000000),0)as   gk03010202000002021530000000,
nvl(sum(gk03010202000002021600000000),0)as   gk03010202000002021600000000,
nvl(sum(gk03010202000002021610000000),0)as   gk03010202000002021610000000,
nvl(sum(gk03010202000002021700000000),0)as   gk03010202000002021700000000,
nvl(sum(gk03010202000002021710000000),0)as   gk03010202000002021710000000,
nvl(sum(gk03010202000002021720000000),0)as   gk03010202000002021720000000,
nvl(sum(gk03010202000002021730000000),0)as   gk03010202000002021730000000,
nvl(sum(gk03010202000010000000000000),0)as   gk03010202000010000000000000,
nvl(sum(gk03010202000010000000010000),0)as   gk03010202000010000000010000,
nvl(sum(gk03010202000010000000010100),0)as   gk03010202000010000000010100,
nvl(sum(gk03010202000010020100000000),0)as   gk03010202000010020100000000,
nvl(sum(gk03010202000010020110000000),0)as   gk03010202000010020110000000,
nvl(sum(gk03010202000010020200000000),0)as   gk03010202000010020200000000,
nvl(sum(gk03010202000010020210000000),0)as   gk03010202000010020210000000,
nvl(sum(gk03010202000010020220000000),0)as   gk03010202000010020220000000,
nvl(sum(gk03010202000010020230000000),0)as   gk03010202000010020230000000,
nvl(sum(gk03010202000010020300000000),0)as   gk03010202000010020300000000,
nvl(sum(gk03010202000010020310000000),0)as   gk03010202000010020310000000,
nvl(sum(gk03010202000010020400000000),0)as   gk03010202000010020400000000,
nvl(sum(gk03010202000010020410000000),0)as   gk03010202000010020410000000,
nvl(sum(gk03010202000010020420000000),0)as   gk03010202000010020420000000,
nvl(sum(gk03010202000010020500000000),0)as   gk03010202000010020500000000,
nvl(sum(gk03010202000010020510000000),0)as   gk03010202000010020510000000,
nvl(sum(gk03010202000010020600000000),0)as   gk03010202000010020600000000,
nvl(sum(gk03010202000010020700000000),0)as   gk03010202000010020700000000,
nvl(sum(gk03010202000010020710000000),0)as   gk03010202000010020710000000,
nvl(sum(gk03010202000010020800000000),0)as   gk03010202000010020800000000,
nvl(sum(gk03010202000010020810000000),0)as   gk03010202000010020810000000,
nvl(sum(gk03010202000010020900000000),0)as   gk03010202000010020900000000,
nvl(sum(gk03010202000010021000000000),0)as   gk03010202000010021000000000,
nvl(sum(gk03010202000010021100000000),0)as   gk03010202000010021100000000,
nvl(sum(gk03010202000010021110000000),0)as   gk03010202000010021110000000,
nvl(sum(gk03010202000010021120000000),0)as   gk03010202000010021120000000,
nvl(sum(gk03010202000010021130000000),0)as   gk03010202000010021130000000,
nvl(sum(gk03010202000010021140000000),0)as   gk03010202000010021140000000,
nvl(sum(gk03010202000010021200000000),0)as   gk03010202000010021200000000,
nvl(sum(gk03010202000010021300000000),0)as   gk03010202000010021300000000,
nvl(sum(gk03010202000010021310000000),0)as   gk03010202000010021310000000,
nvl(sum(gk03010202000010021320000000),0)as   gk03010202000010021320000000,
nvl(sum(gk03010202000010021400000000),0)as   gk03010202000010021400000000,
nvl(sum(gk03010202000010021500000000),0)as   gk03010202000010021500000000,
nvl(sum(gk03010202000010021510000000),0)as   gk03010202000010021510000000,
nvl(sum(gk03010202000010021520000000),0)as   gk03010202000010021520000000,
nvl(sum(gk03010202000010021530000000),0)as   gk03010202000010021530000000,
nvl(sum(gk03010202000010021600000000),0)as   gk03010202000010021600000000,
nvl(sum(gk03010202000010021610000000),0)as   gk03010202000010021610000000,
nvl(sum(gk03010202000010021700000000),0)as   gk03010202000010021700000000,
nvl(sum(gk03010202000010021710000000),0)as   gk03010202000010021710000000,
nvl(sum(gk03010202000010021720000000),0)as   gk03010202000010021720000000,
nvl(sum(gk03010202000010021730000000),0)as   gk03010202000010021730000000,
nvl(sum(gk03010202000011000000000000),0)as   gk03010202000011000000000000,
nvl(sum(gk03010202000011000000010000),0)as   gk03010202000011000000010000,
nvl(sum(gk03010202000011000000010100),0)as   gk03010202000011000000010100,
nvl(sum(gk03010202000011020100000000),0)as   gk03010202000011020100000000,
nvl(sum(gk03010202000011020110000000),0)as   gk03010202000011020110000000,
nvl(sum(gk03010202000011020200000000),0)as   gk03010202000011020200000000,
nvl(sum(gk03010202000011020210000000),0)as   gk03010202000011020210000000,
nvl(sum(gk03010202000011020220000000),0)as   gk03010202000011020220000000,
nvl(sum(gk03010202000011020230000000),0)as   gk03010202000011020230000000,
nvl(sum(gk03010202000011020300000000),0)as   gk03010202000011020300000000,
nvl(sum(gk03010202000011020310000000),0)as   gk03010202000011020310000000,
nvl(sum(gk03010202000011020400000000),0)as   gk03010202000011020400000000,
nvl(sum(gk03010202000011020410000000),0)as   gk03010202000011020410000000,
nvl(sum(gk03010202000011020420000000),0)as   gk03010202000011020420000000,
nvl(sum(gk03010202000011020500000000),0)as   gk03010202000011020500000000,
nvl(sum(gk03010202000011020510000000),0)as   gk03010202000011020510000000,
nvl(sum(gk03010202000011020600000000),0)as   gk03010202000011020600000000,
nvl(sum(gk03010202000011020700000000),0)as   gk03010202000011020700000000,
nvl(sum(gk03010202000011020710000000),0)as   gk03010202000011020710000000,
nvl(sum(gk03010202000011020800000000),0)as   gk03010202000011020800000000,
nvl(sum(gk03010202000011020810000000),0)as   gk03010202000011020810000000,
nvl(sum(gk03010202000011020900000000),0)as   gk03010202000011020900000000,
nvl(sum(gk03010202000011021000000000),0)as   gk03010202000011021000000000,
nvl(sum(gk03010202000011021100000000),0)as   gk03010202000011021100000000,
nvl(sum(gk03010202000011021110000000),0)as   gk03010202000011021110000000,
nvl(sum(gk03010202000011021120000000),0)as   gk03010202000011021120000000,
nvl(sum(gk03010202000011021130000000),0)as   gk03010202000011021130000000,
nvl(sum(gk03010202000011021140000000),0)as   gk03010202000011021140000000,
nvl(sum(gk03010202000011021200000000),0)as   gk03010202000011021200000000,
nvl(sum(gk03010202000011021300000000),0)as   gk03010202000011021300000000,
nvl(sum(gk03010202000011021310000000),0)as   gk03010202000011021310000000,
nvl(sum(gk03010202000011021320000000),0)as   gk03010202000011021320000000,
nvl(sum(gk03010202000011021400000000),0)as   gk03010202000011021400000000,
nvl(sum(gk03010202000011021500000000),0)as   gk03010202000011021500000000,
nvl(sum(gk03010202000011021510000000),0)as   gk03010202000011021510000000,
nvl(sum(gk03010202000011021520000000),0)as   gk03010202000011021520000000,
nvl(sum(gk03010202000011021530000000),0)as   gk03010202000011021530000000,
nvl(sum(gk03010202000011021600000000),0)as   gk03010202000011021600000000,
nvl(sum(gk03010202000011021610000000),0)as   gk03010202000011021610000000,
nvl(sum(gk03010202000011021700000000),0)as   gk03010202000011021700000000,
nvl(sum(gk03010202000011021710000000),0)as   gk03010202000011021710000000,
nvl(sum(gk03010202000011021720000000),0)as   gk03010202000011021720000000,
nvl(sum(gk03010202000011021730000000),0)as   gk03010202000011021730000000,
nvl(sum(gk03010202000012000000000000),0)as   gk03010202000012000000000000,
nvl(sum(gk03010202000012000000010000),0)as   gk03010202000012000000010000,
nvl(sum(gk03010202000012000000010100),0)as   gk03010202000012000000010100,
nvl(sum(gk03010202000012020100000000),0)as   gk03010202000012020100000000,
nvl(sum(gk03010202000012020110000000),0)as   gk03010202000012020110000000,
nvl(sum(gk03010202000012020200000000),0)as   gk03010202000012020200000000,
nvl(sum(gk03010202000012020210000000),0)as   gk03010202000012020210000000,
nvl(sum(gk03010202000012020220000000),0)as   gk03010202000012020220000000,
nvl(sum(gk03010202000012020230000000),0)as   gk03010202000012020230000000,
nvl(sum(gk03010202000012020300000000),0)as   gk03010202000012020300000000,
nvl(sum(gk03010202000012020310000000),0)as   gk03010202000012020310000000,
nvl(sum(gk03010202000012020400000000),0)as   gk03010202000012020400000000,
nvl(sum(gk03010202000012020410000000),0)as   gk03010202000012020410000000,
nvl(sum(gk03010202000012020420000000),0)as   gk03010202000012020420000000,
nvl(sum(gk03010202000012020500000000),0)as   gk03010202000012020500000000,
nvl(sum(gk03010202000012020510000000),0)as   gk03010202000012020510000000,
nvl(sum(gk03010202000012020600000000),0)as   gk03010202000012020600000000,
nvl(sum(gk03010202000012020700000000),0)as   gk03010202000012020700000000,
nvl(sum(gk03010202000012020710000000),0)as   gk03010202000012020710000000,
nvl(sum(gk03010202000012020800000000),0)as   gk03010202000012020800000000,
nvl(sum(gk03010202000012020810000000),0)as   gk03010202000012020810000000,
nvl(sum(gk03010202000012020900000000),0)as   gk03010202000012020900000000,
nvl(sum(gk03010202000012021000000000),0)as   gk03010202000012021000000000,
nvl(sum(gk03010202000012021100000000),0)as   gk03010202000012021100000000,
nvl(sum(gk03010202000012021110000000),0)as   gk03010202000012021110000000,
nvl(sum(gk03010202000012021120000000),0)as   gk03010202000012021120000000,
nvl(sum(gk03010202000012021130000000),0)as   gk03010202000012021130000000,
nvl(sum(gk03010202000012021140000000),0)as   gk03010202000012021140000000,
nvl(sum(gk03010202000012021200000000),0)as   gk03010202000012021200000000,
nvl(sum(gk03010202000012021300000000),0)as   gk03010202000012021300000000,
nvl(sum(gk03010202000012021310000000),0)as   gk03010202000012021310000000,
nvl(sum(gk03010202000012021320000000),0)as   gk03010202000012021320000000,
nvl(sum(gk03010202000012021400000000),0)as   gk03010202000012021400000000,
nvl(sum(gk03010202000012021500000000),0)as   gk03010202000012021500000000,
nvl(sum(gk03010202000012021510000000),0)as   gk03010202000012021510000000,
nvl(sum(gk03010202000012021520000000),0)as   gk03010202000012021520000000,
nvl(sum(gk03010202000012021530000000),0)as   gk03010202000012021530000000,
nvl(sum(gk03010202000012021600000000),0)as   gk03010202000012021600000000,
nvl(sum(gk03010202000012021610000000),0)as   gk03010202000012021610000000,
nvl(sum(gk03010202000012021700000000),0)as   gk03010202000012021700000000,
nvl(sum(gk03010202000012021710000000),0)as   gk03010202000012021710000000,
nvl(sum(gk03010202000012021720000000),0)as   gk03010202000012021720000000,
nvl(sum(gk03010202000012021730000000),0)as   gk03010202000012021730000000,
nvl(sum(gk03010202000020000000000000),0)as   gk03010202000020000000000000,
nvl(sum(gk03010202000020000000010000),0)as   gk03010202000020000000010000,
nvl(sum(gk03010202000020000000010100),0)as   gk03010202000020000000010100,
nvl(sum(gk03010202000020020100000000),0)as   gk03010202000020020100000000,
nvl(sum(gk03010202000020020110000000),0)as   gk03010202000020020110000000,
nvl(sum(gk03010202000020020200000000),0)as   gk03010202000020020200000000,
nvl(sum(gk03010202000020020210000000),0)as   gk03010202000020020210000000,
nvl(sum(gk03010202000020020220000000),0)as   gk03010202000020020220000000,
nvl(sum(gk03010202000020020230000000),0)as   gk03010202000020020230000000,
nvl(sum(gk03010202000020020300000000),0)as   gk03010202000020020300000000,
nvl(sum(gk03010202000020020310000000),0)as   gk03010202000020020310000000,
nvl(sum(gk03010202000020020400000000),0)as   gk03010202000020020400000000,
nvl(sum(gk03010202000020020410000000),0)as   gk03010202000020020410000000,
nvl(sum(gk03010202000020020420000000),0)as   gk03010202000020020420000000,
nvl(sum(gk03010202000020020500000000),0)as   gk03010202000020020500000000,
nvl(sum(gk03010202000020020510000000),0)as   gk03010202000020020510000000,
nvl(sum(gk03010202000020020600000000),0)as   gk03010202000020020600000000,
nvl(sum(gk03010202000020020700000000),0)as   gk03010202000020020700000000,
nvl(sum(gk03010202000020020710000000),0)as   gk03010202000020020710000000,
nvl(sum(gk03010202000020020800000000),0)as   gk03010202000020020800000000,
nvl(sum(gk03010202000020020810000000),0)as   gk03010202000020020810000000,
nvl(sum(gk03010202000020020900000000),0)as   gk03010202000020020900000000,
nvl(sum(gk03010202000020021000000000),0)as   gk03010202000020021000000000,
nvl(sum(gk03010202000020021100000000),0)as   gk03010202000020021100000000,
nvl(sum(gk03010202000020021110000000),0)as   gk03010202000020021110000000,
nvl(sum(gk03010202000020021120000000),0)as   gk03010202000020021120000000,
nvl(sum(gk03010202000020021130000000),0)as   gk03010202000020021130000000,
nvl(sum(gk03010202000020021140000000),0)as   gk03010202000020021140000000,
nvl(sum(gk03010202000020021200000000),0)as   gk03010202000020021200000000,
nvl(sum(gk03010202000020021300000000),0)as   gk03010202000020021300000000,
nvl(sum(gk03010202000020021310000000),0)as   gk03010202000020021310000000,
nvl(sum(gk03010202000020021320000000),0)as   gk03010202000020021320000000,
nvl(sum(gk03010202000020021400000000),0)as   gk03010202000020021400000000,
nvl(sum(gk03010202000020021500000000),0)as   gk03010202000020021500000000,
nvl(sum(gk03010202000020021510000000),0)as   gk03010202000020021510000000,
nvl(sum(gk03010202000020021520000000),0)as   gk03010202000020021520000000,
nvl(sum(gk03010202000020021530000000),0)as   gk03010202000020021530000000,
nvl(sum(gk03010202000020021600000000),0)as   gk03010202000020021600000000,
nvl(sum(gk03010202000020021610000000),0)as   gk03010202000020021610000000,
nvl(sum(gk03010202000020021700000000),0)as   gk03010202000020021700000000,
nvl(sum(gk03010202000020021710000000),0)as   gk03010202000020021710000000,
nvl(sum(gk03010202000020021720000000),0)as   gk03010202000020021720000000,
nvl(sum(gk03010202000020021730000000),0)as   gk03010202000020021730000000,
nvl(sum(gk03010202000021000000000000),0)as   gk03010202000021000000000000,
nvl(sum(gk03010202000021000000010000),0)as   gk03010202000021000000010000,
nvl(sum(gk03010202000021000000010100),0)as   gk03010202000021000000010100,
nvl(sum(gk03010202000021020100000000),0)as   gk03010202000021020100000000,
nvl(sum(gk03010202000021020110000000),0)as   gk03010202000021020110000000,
nvl(sum(gk03010202000021020200000000),0)as   gk03010202000021020200000000,
nvl(sum(gk03010202000021020210000000),0)as   gk03010202000021020210000000,
nvl(sum(gk03010202000021020220000000),0)as   gk03010202000021020220000000,
nvl(sum(gk03010202000021020230000000),0)as   gk03010202000021020230000000,
nvl(sum(gk03010202000021020300000000),0)as   gk03010202000021020300000000,
nvl(sum(gk03010202000021020310000000),0)as   gk03010202000021020310000000,
nvl(sum(gk03010202000021020400000000),0)as   gk03010202000021020400000000,
nvl(sum(gk03010202000021020410000000),0)as   gk03010202000021020410000000,
nvl(sum(gk03010202000021020420000000),0)as   gk03010202000021020420000000,
nvl(sum(gk03010202000021020500000000),0)as   gk03010202000021020500000000,
nvl(sum(gk03010202000021020510000000),0)as   gk03010202000021020510000000,
nvl(sum(gk03010202000021020600000000),0)as   gk03010202000021020600000000,
nvl(sum(gk03010202000021020700000000),0)as   gk03010202000021020700000000,
nvl(sum(gk03010202000021020710000000),0)as   gk03010202000021020710000000,
nvl(sum(gk03010202000021020800000000),0)as   gk03010202000021020800000000,
nvl(sum(gk03010202000021020810000000),0)as   gk03010202000021020810000000,
nvl(sum(gk03010202000021020900000000),0)as   gk03010202000021020900000000,
nvl(sum(gk03010202000021021000000000),0)as   gk03010202000021021000000000,
nvl(sum(gk03010202000021021100000000),0)as   gk03010202000021021100000000,
nvl(sum(gk03010202000021021110000000),0)as   gk03010202000021021110000000,
nvl(sum(gk03010202000021021120000000),0)as   gk03010202000021021120000000,
nvl(sum(gk03010202000021021130000000),0)as   gk03010202000021021130000000,
nvl(sum(gk03010202000021021140000000),0)as   gk03010202000021021140000000,
nvl(sum(gk03010202000021021200000000),0)as   gk03010202000021021200000000,
nvl(sum(gk03010202000021021300000000),0)as   gk03010202000021021300000000,
nvl(sum(gk03010202000021021310000000),0)as   gk03010202000021021310000000,
nvl(sum(gk03010202000021021320000000),0)as   gk03010202000021021320000000,
nvl(sum(gk03010202000021021400000000),0)as   gk03010202000021021400000000,
nvl(sum(gk03010202000021021500000000),0)as   gk03010202000021021500000000,
nvl(sum(gk03010202000021021510000000),0)as   gk03010202000021021510000000,
nvl(sum(gk03010202000021021520000000),0)as   gk03010202000021021520000000,
nvl(sum(gk03010202000021021530000000),0)as   gk03010202000021021530000000,
nvl(sum(gk03010202000021021600000000),0)as   gk03010202000021021600000000,
nvl(sum(gk03010202000021021610000000),0)as   gk03010202000021021610000000,
nvl(sum(gk03010202000021021700000000),0)as   gk03010202000021021700000000,
nvl(sum(gk03010202000021021710000000),0)as   gk03010202000021021710000000,
nvl(sum(gk03010202000021021720000000),0)as   gk03010202000021021720000000,
nvl(sum(gk03010202000021021730000000),0)as   gk03010202000021021730000000,
nvl(sum(gk03010202000022000000000000),0)as   gk03010202000022000000000000,
nvl(sum(gk03010202000022000000010000),0)as   gk03010202000022000000010000,
nvl(sum(gk03010202000022000000010100),0)as   gk03010202000022000000010100,
nvl(sum(gk03010202000022020100000000),0)as   gk03010202000022020100000000,
nvl(sum(gk03010202000022020110000000),0)as   gk03010202000022020110000000,
nvl(sum(gk03010202000022020200000000),0)as   gk03010202000022020200000000,
nvl(sum(gk03010202000022020210000000),0)as   gk03010202000022020210000000,
nvl(sum(gk03010202000022020220000000),0)as   gk03010202000022020220000000,
nvl(sum(gk03010202000022020230000000),0)as   gk03010202000022020230000000,
nvl(sum(gk03010202000022020300000000),0)as   gk03010202000022020300000000,
nvl(sum(gk03010202000022020310000000),0)as   gk03010202000022020310000000,
nvl(sum(gk03010202000022020400000000),0)as   gk03010202000022020400000000,
nvl(sum(gk03010202000022020410000000),0)as   gk03010202000022020410000000,
nvl(sum(gk03010202000022020420000000),0)as   gk03010202000022020420000000,
nvl(sum(gk03010202000022020500000000),0)as   gk03010202000022020500000000,
nvl(sum(gk03010202000022020510000000),0)as   gk03010202000022020510000000,
nvl(sum(gk03010202000022020600000000),0)as   gk03010202000022020600000000,
nvl(sum(gk03010202000022020700000000),0)as   gk03010202000022020700000000,
nvl(sum(gk03010202000022020710000000),0)as   gk03010202000022020710000000,
nvl(sum(gk03010202000022020800000000),0)as   gk03010202000022020800000000,
nvl(sum(gk03010202000022020810000000),0)as   gk03010202000022020810000000,
nvl(sum(gk03010202000022020900000000),0)as   gk03010202000022020900000000,
nvl(sum(gk03010202000022021000000000),0)as   gk03010202000022021000000000,
nvl(sum(gk03010202000022021100000000),0)as   gk03010202000022021100000000,
nvl(sum(gk03010202000022021110000000),0)as   gk03010202000022021110000000,
nvl(sum(gk03010202000022021120000000),0)as   gk03010202000022021120000000,
nvl(sum(gk03010202000022021130000000),0)as   gk03010202000022021130000000,
nvl(sum(gk03010202000022021140000000),0)as   gk03010202000022021140000000,
nvl(sum(gk03010202000022021200000000),0)as   gk03010202000022021200000000,
nvl(sum(gk03010202000022021300000000),0)as   gk03010202000022021300000000,
nvl(sum(gk03010202000022021310000000),0)as   gk03010202000022021310000000,
nvl(sum(gk03010202000022021320000000),0)as   gk03010202000022021320000000,
nvl(sum(gk03010202000022021400000000),0)as   gk03010202000022021400000000,
nvl(sum(gk03010202000022021500000000),0)as   gk03010202000022021500000000,
nvl(sum(gk03010202000022021510000000),0)as   gk03010202000022021510000000,
nvl(sum(gk03010202000022021520000000),0)as   gk03010202000022021520000000,
nvl(sum(gk03010202000022021530000000),0)as   gk03010202000022021530000000,
nvl(sum(gk03010202000022021600000000),0)as   gk03010202000022021600000000,
nvl(sum(gk03010202000022021610000000),0)as   gk03010202000022021610000000,
nvl(sum(gk03010202000022021700000000),0)as   gk03010202000022021700000000,
nvl(sum(gk03010202000022021710000000),0)as   gk03010202000022021710000000,
nvl(sum(gk03010202000022021720000000),0)as   gk03010202000022021720000000,
nvl(sum(gk03010202000022021730000000),0)as   gk03010202000022021730000000,
nvl((sum(gk03010202000100000000010000)+sum(gk03010202000100000000010100)),0) as GK03010202000100020000000000
from JTG_05Y a,JTGZ_030405 b,JTGZ_0405 c
where a.DATATIME=b.DATATIME and  b.DATATIME = c.DATATIME
group by a.DATATIME;


create or replace view gk_share_jsjy_hj_fhlttl_v as
select t."TJ_MONTH",t."GK03010202000100020000000000",t."GK03010202000000000000000000",t."GK03010202000000000000010000",t."GK03010202000000000000010100",t."GK03010202000000020100000000",t."GK03010202000000020110000000",t."GK03010202000000020200000000",t."GK03010202000000020210000000",t."GK03010202000000020220000000",t."GK03010202000000020230000000",t."GK03010202000000020300000000",t."GK03010202000000020310000000",t."GK03010202000000020400000000",t."GK03010202000000020410000000",t."GK03010202000000020420000000",t."GK03010202000000020500000000",t."GK03010202000000020510000000",t."GK03010202000000020600000000",t."GK03010202000000020700000000",t."GK03010202000000020710000000",t."GK03010202000000020800000000",t."GK03010202000000020810000000",t."GK03010202000000020900000000",t."GK03010202000000021000000000",t."GK03010202000000021100000000",t."GK03010202000000021110000000",t."GK03010202000000021120000000",t."GK03010202000000021130000000",t."GK03010202000000021140000000",t."GK03010202000000021200000000",t."GK03010202000000021300000000",t."GK03010202000000021310000000",t."GK03010202000000021320000000",t."GK03010202000000021400000000",t."GK03010202000000021500000000",t."GK03010202000000021510000000",t."GK03010202000000021520000000",t."GK03010202000000021530000000",t."GK03010202000000021600000000",t."GK03010202000000021610000000",t."GK03010202000000021700000000",t."GK03010202000000021710000000",t."GK03010202000000021720000000",t."GK03010202000000021730000000",t."GK03010202000001000000000000",t."GK03010202000001000000010000",t."GK03010202000001000000010100",t."GK03010202000001020100000000",t."GK03010202000001020110000000",t."GK03010202000001020200000000",t."GK03010202000001020210000000",t."GK03010202000001020220000000",t."GK03010202000001020230000000",t."GK03010202000001020300000000",t."GK03010202000001020310000000",t."GK03010202000001020400000000",t."GK03010202000001020410000000",t."GK03010202000001020420000000",t."GK03010202000001020500000000",t."GK03010202000001020510000000",t."GK03010202000001020600000000",t."GK03010202000001020700000000",t."GK03010202000001020710000000",t."GK03010202000001020800000000",t."GK03010202000001020810000000",t."GK03010202000001020900000000",t."GK03010202000001021000000000",t."GK03010202000001021100000000",t."GK03010202000001021110000000",t."GK03010202000001021120000000",t."GK03010202000001021130000000",t."GK03010202000001021140000000",t."GK03010202000001021200000000",t."GK03010202000001021300000000",t."GK03010202000001021310000000",t."GK03010202000001021320000000",t."GK03010202000001021400000000",t."GK03010202000001021500000000",t."GK03010202000001021510000000",t."GK03010202000001021520000000",t."GK03010202000001021530000000",t."GK03010202000001021600000000",t."GK03010202000001021610000000",t."GK03010202000001021700000000",t."GK03010202000001021710000000",t."GK03010202000001021720000000",t."GK03010202000001021730000000",t."GK03010202000002000000000000",t."GK03010202000002000000010000",t."GK03010202000002000000010100",t."GK03010202000002020100000000",t."GK03010202000002020110000000",t."GK03010202000002020200000000",t."GK03010202000002020210000000",t."GK03010202000002020220000000",t."GK03010202000002020230000000",t."GK03010202000002020300000000",t."GK03010202000002020310000000",t."GK03010202000002020400000000",t."GK03010202000002020410000000",t."GK03010202000002020420000000",t."GK03010202000002020500000000",t."GK03010202000002020510000000",t."GK03010202000002020600000000",t."GK03010202000002020700000000",t."GK03010202000002020710000000",t."GK03010202000002020800000000",t."GK03010202000002020810000000",t."GK03010202000002020900000000",t."GK03010202000002021000000000",t."GK03010202000002021100000000",t."GK03010202000002021110000000",t."GK03010202000002021120000000",t."GK03010202000002021130000000",t."GK03010202000002021140000000",t."GK03010202000002021200000000",t."GK03010202000002021300000000",t."GK03010202000002021310000000",t."GK03010202000002021320000000",t."GK03010202000002021400000000",t."GK03010202000002021500000000",t."GK03010202000002021510000000",t."GK03010202000002021520000000",t."GK03010202000002021530000000",t."GK03010202000002021600000000",t."GK03010202000002021610000000",t."GK03010202000002021700000000",t."GK03010202000002021710000000",t."GK03010202000002021720000000",t."GK03010202000002021730000000",t."GK03010202000010000000000000",t."GK03010202000010000000010000",t."GK03010202000010000000010100",t."GK03010202000010020100000000",t."GK03010202000010020110000000",t."GK03010202000010020200000000",t."GK03010202000010020210000000",t."GK03010202000010020220000000",t."GK03010202000010020230000000",t."GK03010202000010020300000000",t."GK03010202000010020310000000",t."GK03010202000010020400000000",t."GK03010202000010020410000000",t."GK03010202000010020420000000",t."GK03010202000010020500000000",t."GK03010202000010020510000000",t."GK03010202000010020600000000",t."GK03010202000010020700000000",t."GK03010202000010020710000000",t."GK03010202000010020800000000",t."GK03010202000010020810000000",t."GK03010202000010020900000000",t."GK03010202000010021000000000",t."GK03010202000010021100000000",t."GK03010202000010021110000000",t."GK03010202000010021120000000",t."GK03010202000010021130000000",t."GK03010202000010021140000000",t."GK03010202000010021200000000",t."GK03010202000010021300000000",t."GK03010202000010021310000000",t."GK03010202000010021320000000",t."GK03010202000010021400000000",t."GK03010202000010021500000000",t."GK03010202000010021510000000",t."GK03010202000010021520000000",t."GK03010202000010021530000000",t."GK03010202000010021600000000",t."GK03010202000010021610000000",t."GK03010202000010021700000000",t."GK03010202000010021710000000",t."GK03010202000010021720000000",t."GK03010202000010021730000000",t."GK03010202000011000000000000",t."GK03010202000011000000010000",t."GK03010202000011000000010100",t."GK03010202000011020100000000",t."GK03010202000011020110000000",t."GK03010202000011020200000000",t."GK03010202000011020210000000",t."GK03010202000011020220000000",t."GK03010202000011020230000000",t."GK03010202000011020300000000",t."GK03010202000011020310000000",t."GK03010202000011020400000000",t."GK03010202000011020410000000",t."GK03010202000011020420000000",t."GK03010202000011020500000000",t."GK03010202000011020510000000",t."GK03010202000011020600000000",t."GK03010202000011020700000000",t."GK03010202000011020710000000",t."GK03010202000011020800000000",t."GK03010202000011020810000000",t."GK03010202000011020900000000",t."GK03010202000011021000000000",t."GK03010202000011021100000000",t."GK03010202000011021110000000",t."GK03010202000011021120000000",t."GK03010202000011021130000000",t."GK03010202000011021140000000",t."GK03010202000011021200000000",t."GK03010202000011021300000000",t."GK03010202000011021310000000",t."GK03010202000011021320000000",t."GK03010202000011021400000000",t."GK03010202000011021500000000",t."GK03010202000011021510000000",t."GK03010202000011021520000000",t."GK03010202000011021530000000",t."GK03010202000011021600000000",t."GK03010202000011021610000000",t."GK03010202000011021700000000",t."GK03010202000011021710000000",t."GK03010202000011021720000000",t."GK03010202000011021730000000",t."GK03010202000012000000000000",t."GK03010202000012000000010000",t."GK03010202000012000000010100",t."GK03010202000012020100000000",t."GK03010202000012020110000000",t."GK03010202000012020200000000",t."GK03010202000012020210000000",t."GK03010202000012020220000000",t."GK03010202000012020230000000",t."GK03010202000012020300000000",t."GK03010202000012020310000000",t."GK03010202000012020400000000",t."GK03010202000012020410000000",t."GK03010202000012020420000000",t."GK03010202000012020500000000",t."GK03010202000012020510000000",t."GK03010202000012020600000000",t."GK03010202000012020700000000",t."GK03010202000012020710000000",t."GK03010202000012020800000000",t."GK03010202000012020810000000",t."GK03010202000012020900000000",t."GK03010202000012021000000000",t."GK03010202000012021100000000",t."GK03010202000012021110000000",t."GK03010202000012021120000000",t."GK03010202000012021130000000",t."GK03010202000012021140000000",t."GK03010202000012021200000000",t."GK03010202000012021300000000",t."GK03010202000012021310000000",t."GK03010202000012021320000000",t."GK03010202000012021400000000",t."GK03010202000012021500000000",t."GK03010202000012021510000000",t."GK03010202000012021520000000",t."GK03010202000012021530000000",t."GK03010202000012021600000000",t."GK03010202000012021610000000",t."GK03010202000012021700000000",t."GK03010202000012021710000000",t."GK03010202000012021720000000",t."GK03010202000012021730000000",t."GK03010202000020000000000000",t."GK03010202000020000000010000",t."GK03010202000020000000010100",t."GK03010202000020020100000000",t."GK03010202000020020110000000",t."GK03010202000020020200000000",t."GK03010202000020020210000000",t."GK03010202000020020220000000",t."GK03010202000020020230000000",t."GK03010202000020020300000000",t."GK03010202000020020310000000",t."GK03010202000020020400000000",t."GK03010202000020020410000000",t."GK03010202000020020420000000",t."GK03010202000020020500000000",t."GK03010202000020020510000000",t."GK03010202000020020600000000",t."GK03010202000020020700000000",t."GK03010202000020020710000000",t."GK03010202000020020800000000",t."GK03010202000020020810000000",t."GK03010202000020020900000000",t."GK03010202000020021000000000",t."GK03010202000020021100000000",t."GK03010202000020021110000000",t."GK03010202000020021120000000",t."GK03010202000020021130000000",t."GK03010202000020021140000000",t."GK03010202000020021200000000",t."GK03010202000020021300000000",t."GK03010202000020021310000000",t."GK03010202000020021320000000",t."GK03010202000020021400000000",t."GK03010202000020021500000000",t."GK03010202000020021510000000",t."GK03010202000020021520000000",t."GK03010202000020021530000000",t."GK03010202000020021600000000",t."GK03010202000020021610000000",t."GK03010202000020021700000000",t."GK03010202000020021710000000",t."GK03010202000020021720000000",t."GK03010202000020021730000000",t."GK03010202000021000000000000",t."GK03010202000021000000010000",t."GK03010202000021000000010100",t."GK03010202000021020100000000",t."GK03010202000021020110000000",t."GK03010202000021020200000000",t."GK03010202000021020210000000",t."GK03010202000021020220000000",t."GK03010202000021020230000000",t."GK03010202000021020300000000",t."GK03010202000021020310000000",t."GK03010202000021020400000000",t."GK03010202000021020410000000",t."GK03010202000021020420000000",t."GK03010202000021020500000000",t."GK03010202000021020510000000",t."GK03010202000021020600000000",t."GK03010202000021020700000000",t."GK03010202000021020710000000",t."GK03010202000021020800000000",t."GK03010202000021020810000000",t."GK03010202000021020900000000",t."GK03010202000021021000000000",t."GK03010202000021021100000000",t."GK03010202000021021110000000",t."GK03010202000021021120000000",t."GK03010202000021021130000000",t."GK03010202000021021140000000",t."GK03010202000021021200000000",t."GK03010202000021021300000000",t."GK03010202000021021310000000",t."GK03010202000021021320000000",t."GK03010202000021021400000000",t."GK03010202000021021500000000",t."GK03010202000021021510000000",t."GK03010202000021021520000000",t."GK03010202000021021530000000",t."GK03010202000021021600000000",t."GK03010202000021021610000000",t."GK03010202000021021700000000",t."GK03010202000021021710000000",t."GK03010202000021021720000000",t."GK03010202000021021730000000",t."GK03010202000022000000000000",t."GK03010202000022000000010000",t."GK03010202000022000000010100",t."GK03010202000022020100000000",t."GK03010202000022020110000000",t."GK03010202000022020200000000",t."GK03010202000022020210000000",t."GK03010202000022020220000000",t."GK03010202000022020230000000",t."GK03010202000022020300000000",t."GK03010202000022020310000000",t."GK03010202000022020400000000",t."GK03010202000022020410000000",t."GK03010202000022020420000000",t."GK03010202000022020500000000",t."GK03010202000022020510000000",t."GK03010202000022020600000000",t."GK03010202000022020700000000",t."GK03010202000022020710000000",t."GK03010202000022020800000000",t."GK03010202000022020810000000",t."GK03010202000022020900000000",t."GK03010202000022021000000000",t."GK03010202000022021100000000",t."GK03010202000022021110000000",t."GK03010202000022021120000000",t."GK03010202000022021130000000",t."GK03010202000022021140000000",t."GK03010202000022021200000000",t."GK03010202000022021300000000",t."GK03010202000022021310000000",t."GK03010202000022021320000000",t."GK03010202000022021400000000",t."GK03010202000022021500000000",t."GK03010202000022021510000000",t."GK03010202000022021520000000",t."GK03010202000022021530000000",t."GK03010202000022021600000000",t."GK03010202000022021610000000",t."GK03010202000022021700000000",t."GK03010202000022021710000000",t."GK03010202000022021720000000",t."GK03010202000022021730000000",
         sysdate as create_date_time,
         sysdate as update_date_time,
         null as create_user,
         null as update_user,
         '900' as szd,
         1 as record_status,
         'Y' as sftb,
         'N' as tbzt
    from GK_SHARE_JSJY_HJ_FHLTTL_MV t;
create or replace view gk_share_jsjy_hj_jzxttl_v as
select   substr(a.datatime,0,4)||'-'||substr(a.datatime,8,2) as tj_month,
  nvl(sum(gk03010202000001114100000000),0) as gk03010202000001114100000000,
  nvl(sum(gk03010202000001214100000000),0) as gk03010202000001214100000000,
  nvl(sum(gk03010202000002014100000000),0) as gk03010202000002014100000000,
  nvl(sum(gk03010202000001114110000000),0) as gk03010202000001114110000000,
  nvl(sum(gk03010202000001214110000000),0) as gk03010202000001214110000000,
  nvl(sum(gk03010202000002014110000000),0) as gk03010202000002014110000000,
  nvl(sum(gk03010202000001114111000000),0) as gk03010202000001114111000000,
  nvl(sum(gk03010202000001214111000000),0) as gk03010202000001214111000000,
  nvl(sum(gk03010202000002014111000000),0) as gk03010202000002014111000000,
  nvl(sum(gk03010202000001114112000000),0) as gk03010202000001114112000000,
  nvl(sum(gk03010202000001214112000000),0) as gk03010202000001214112000000,
  nvl(sum(gk03010202000002014112000000),0) as gk03010202000002014112000000,
  nvl(sum(gk03010202000001114113000000),0) as gk03010202000001114113000000,
  nvl(sum(gk03010202000001214113000000),0) as gk03010202000001214113000000,
  nvl(sum(gk03010202000002014113000000),0) as gk03010202000002014113000000,
  nvl(sum(gk03010202000001114119000000),0) as gk03010202000001114119000000,
  nvl(sum(gk03010202000001214119000000),0) as gk03010202000001214119000000,
  nvl(sum(gk03010202000002014119000000),0) as gk03010202000002014119000000,
  nvl(sum(gk03010202000001114120000000),0) as gk03010202000001114120000000,
  nvl(sum(gk03010202000001214120000000),0) as gk03010202000001214120000000,
  nvl(sum(gk03010202000002014120000000),0) as gk03010202000002014120000000,
  nvl(sum(gk03010202000001114121000000),0) as gk03010202000001114121000000,
  nvl(sum(gk03010202000001214121000000),0) as gk03010202000001214121000000,
  nvl(sum(gk03010202000002014121000000),0) as gk03010202000002014121000000,
  nvl(sum(gk03010202000001114122000000),0) as gk03010202000001114122000000,
  nvl(sum(gk03010202000001214122000000),0) as gk03010202000001214122000000,
  nvl(sum(gk03010202000002014122000000),0) as gk03010202000002014122000000,
  nvl(sum(gk03010202000001114123000000),0) as gk03010202000001114123000000,
  nvl(sum(gk03010202000001214123000000),0) as gk03010202000001214123000000,
  nvl(sum(gk03010202000002014123000000),0) as gk03010202000002014123000000,
  nvl(sum(gk03010202000001114129000000),0) as gk03010202000001114129000000,
  nvl(sum(gk03010202000001214129000000),0) as gk03010202000001214129000000,
  nvl(sum(gk03010202000002014129000000),0) as gk03010202000002014129000000,
  nvl(sum(gk03010202000001114200000000),0) as gk03010202000001114200000000,
  nvl(sum(gk03010202000001214200000000),0) as gk03010202000001214200000000,
  nvl(sum(gk03010202000002014200000000),0) as gk03010202000002014200000000,
  nvl(sum(gk03010202000001114300000000),0) as gk03010202000001114300000000,
  nvl(sum(gk03010202000001214300000000),0) as gk03010202000001214300000000,
  nvl(sum(gk03010202000002014300000000),0) as gk03010202000002014300000000,
  nvl(sum(gk03010202000001114100000000)+sum(gk03010202000001214100000000)+sum(gk03010202000002014100000000),0) as gk03010202000000014100000000,
  nvl(sum(gk03010202000000014110000000),0) as gk03010202000000014110000000,
  nvl(sum(gk03010202000000014111000000),0) as gk03010202000000014111000000,
  nvl(sum(gk03010202000000014112000000),0) as gk03010202000000014112000000,
  nvl(sum(gk03010202000000014113000000),0) as gk03010202000000014113000000,
  nvl(sum(gk03010202000000014119000000),0) as gk03010202000000014119000000,
  nvl(sum(gk03010202000000014120000000),0) as gk03010202000000014120000000,
  nvl(sum(gk03010202000000014121000000),0) as gk03010202000000014121000000,
  nvl(sum(gk03010202000000014122000000),0) as gk03010202000000014122000000,
  nvl(sum(gk03010202000000014123000000),0) as gk03010202000000014123000000,
  nvl(sum(gk03010202000000014129000000),0) as gk03010202000000014129000000,
  nvl(sum(gk03010202000001114200000000) + sum(gk03010202000001214200000000)+ sum(gk03010202000002014200000000),0)  as gk03010202000000014200000000,
  nvl(sum(gk03010202000001114300000000) + sum(gk03010202000001214300000000)+ sum(gk03010202000002014300000000),0)  as gk03010202000000014300000000
  from JTGZ_0410 a ,JTG_10_GD b
  where a.DATATIME=b.DATATIME
group by a.DATATIME;