是不是存在最大值相同的情况呢,只取一条就行了
select CUR_SUM,CUR_APEX,CUR_LOW,CUR_FLAT,CUR_TOP INTO prisum,priapex,prilow,priflat,pritop FROM MONTH_RECORD
WHERE (METER_NO = curmeterno) and (REC_MONTH = priym)
and rownum=1;//取一条
select CUR_SUM,CUR_APEX,CUR_LOW,CUR_FLAT,CUR_TOP INTO prisum,priapex,prilow,priflat,pritop FROM MONTH_RECORD
WHERE (METER_NO = curmeterno) and (REC_MONTH = priym)
and rownum=1;//取一条
1、curym,priym number;这句不对,变量定义必须一个一个来,改成:
curym NUMBER;
priym NUMBER;
2、在行级触发器中,不能对本表操作,所以
SELECT MAX (rec_month)
INTO priym
FROM month_record
WHERE (rec_month < curym) AND (meter_no = curmeterno);
在执行过程中会出错