摘要： //先给 BMC_CPU_INFOS 加上GNUM 字段来对每一个十分钟进行区分ALTER TABLEBMC_CPU_INFOS ADDGNUM number(10);//MM是‘08:05’这样的时间字符串//SUBSTR(MM, 1, 1)取小时的十位数，SUBSTR(MM, 2, 1)取小时的个位数，SUBSTR(MM, 4, 1)取分钟的十位数update BMC_CPU_INFOS set GNUM = TO_NUMBER(SUBSTR(MM, 1, 1))*60+TO_NUMBER(SUBSTR(MM, 2, 1))*6+TO_NUMBER(SUBSTR(MM, 4, 1)) .. 阅读全文