CURSOR mycursor IS
SELECT A.HPHM,A.HPZL, B.MC AS ny FROM VEHICLE A,DM_HPZL B WHERE A.HPZL=B.DM;改为:
CURSOR mycursor IS
SELECT A.HPHM,A.HPZL, B.MC FROM VEHICLE A,DM_HPZL B WHERE A.HPZL=B.DM;
SELECT A.HPHM,A.HPZL, B.MC AS ny FROM VEHICLE A,DM_HPZL B WHERE A.HPZL=B.DM;改为:
CURSOR mycursor IS
SELECT A.HPHM,A.HPZL, B.MC FROM VEHICLE A,DM_HPZL B WHERE A.HPZL=B.DM;
改为:
UPDATE VEHICLE SET VEHICLE.TEMP1= v_ny WHERE VEHICLE.HPHM= V_CPHM AND VEHICLE.HPZL=V_CPZL;