动态SQL现实一个表中求多列的和
1、建表（注：96DATA_VALUE字段分别为一天每15分钟的监测数据，避免一天一个用户产生96条数据，可以减少表的数据量，因为全国用电客户巨大）
-- Create table create table EESMP.R_H_CURVE_E ( MS_ID NUMBER(9) not null, DATA_ITEM_CODE VARCHAR2(16) not null, DATA_DATE VARCHAR2(8) not null, RECORD_NO NUMBER(5) not null, CURVE_DENSITY VARCHAR2(8), DATA_VALUE1 NUMBER(12,4), DATA_VALUE2 NUMBER(12,4), DATA_VALUE3 NUMBER(12,4), DATA_VALUE4 NUMBER(12,4), DATA_VALUE5 NUMBER(12,4), DATA_VALUE6 NUMBER(12,4), DATA_VALUE7 NUMBER(12,4), DATA_VALUE8 NUMBER(12,4), DATA_VALUE9 NUMBER(12,4), DATA_VALUE10 NUMBER(12,4), DATA_VALUE11 NUMBER(12,4), DATA_VALUE12 NUMBER(12,4), DATA_VALUE13 NUMBER(12,4), DATA_VALUE14 NUMBER(12,4), DATA_VALUE15 NUMBER(12,4), DATA_VALUE16 NUMBER(12,4), DATA_VALUE17 NUMBER(12,4), DATA_VALUE18 NUMBER(12,4), DATA_VALUE19 NUMBER(12,4), DATA_VALUE20 NUMBER(12,4), DATA_VALUE21 NUMBER(12,4), DATA_VALUE22 NUMBER(12,4), DATA_VALUE23 NUMBER(12,4), DATA_VALUE24 NUMBER(12,4), DATA_VALUE25 NUMBER(12,4), DATA_VALUE26 NUMBER(12,4), DATA_VALUE27 NUMBER(12,4), DATA_VALUE28 NUMBER(12,4), DATA_VALUE29 NUMBER(12,4), DATA_VALUE30 NUMBER(12,4), DATA_VALUE31 NUMBER(12,4), DATA_VALUE32 NUMBER(12,4), DATA_VALUE33 NUMBER(12,4), DATA_VALUE34 NUMBER(12,4), DATA_VALUE35 NUMBER(12,4), DATA_VALUE36 NUMBER(12,4), DATA_VALUE37 NUMBER(12,4), DATA_VALUE38 NUMBER(12,4), DATA_VALUE39 NUMBER(12,4), DATA_VALUE40 NUMBER(12,4), DATA_VALUE41 NUMBER(12,4), DATA_VALUE42 NUMBER(12,4),DATA_VALUE43 NUMBER(12,4), DATA_VALUE44 NUMBER(12,4), DATA_VALUE45 NUMBER(12,4), DATA_VALUE46 NUMBER(12,4), DATA_VALUE47 NUMBER(12,4), DATA_VALUE48 NUMBER(12,4), DATA_VALUE49 NUMBER(12,4), DATA_VALUE50 NUMBER(12,4), DATA_VALUE51 NUMBER(12,4), DATA_VALUE52 NUMBER(12,4), DATA_VALUE53 NUMBER(12,4), DATA_VALUE54 NUMBER(12,4), DATA_VALUE55 NUMBER(12,4), DATA_VALUE56 NUMBER(12,4), DATA_VALUE57 NUMBER(12,4), DATA_VALUE58 NUMBER(12,4), DATA_VALUE59 NUMBER(12,4), DATA_VALUE60 NUMBER(12,4), DATA_VALUE61 NUMBER(12,4), DATA_VALUE62 NUMBER(12,4), DATA_VALUE63 NUMBER(12,4), DATA_VALUE64 NUMBER(12,4), DATA_VALUE65 NUMBER(12,4), DATA_VALUE66 NUMBER(12,4), DATA_VALUE67 NUMBER(12,4), DATA_VALUE68 NUMBER(12,4), DATA_VALUE69 NUMBER(12,4), DATA_VALUE70 NUMBER(12,4), DATA_VALUE71 NUMBER(12,4), DATA_VALUE72 NUMBER(12,4), DATA_VALUE73 NUMBER(12,4), DATA_VALUE74 NUMBER(12,4), DATA_VALUE75 NUMBER(12,4), DATA_VALUE76 NUMBER(12,4), DATA_VALUE77 NUMBER(12,4), DATA_VALUE78 NUMBER(12,4), DATA_VALUE79 NUMBER(12,4), DATA_VALUE80 NUMBER(12,4), DATA_VALUE81 NUMBER(12,4), DATA_VALUE82 NUMBER(12,4), DATA_VALUE83 NUMBER(12,4), DATA_VALUE84 NUMBER(12,4), DATA_VALUE85 NUMBER(12,4), DATA_VALUE86 NUMBER(12,4), DATA_VALUE87 NUMBER(12,4), DATA_VALUE88 NUMBER(12,4), DATA_VALUE89 NUMBER(12,4), DATA_VALUE90 NUMBER(12,4), DATA_VALUE91 NUMBER(12,4), DATA_VALUE92 NUMBER(12,4), DATA_VALUE93 NUMBER(12,4), DATA_VALUE94 NUMBER(12,4), DATA_VALUE95 NUMBER(12,4), DATA_VALUE96 NUMBER(12,4), DATA_TYPE VARCHAR2(8) not null ) tablespace DATA_TEST pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next