开心每一天1111
oracle 里面 := 是 存储过程的 赋值的意思例如:SQL> DECLARE2 testvalue VARCHAR2(20);3 BEGIN4 testvalue := 'First Test!';5 dbms_output.put_line( testvalue );6 END;7 /First Test!PL/SQL procedure successfully completed.至于 =:这个我怀疑, 有可能是 触发器里面的判断处理例如:CREATE OR REPLACE TRIGGER BeforeInsertDetailBEFORE INSERT ON OrderDetailFOR EACH ROWDECLARE v_nowCount INT;BEGINSELECTAmount INTO v_nowCountFROMGoodsWHEREID = :new.GoodsID;IF v_nowCount - :new.Amount < 0 THENRAISE_APPLICATION_ERROR(-20000, '库存不足!');ELSEUPDATEGoodsSETAmount = Amount - :new.AmountWHEREID = :new.GoodsID;END IF;END;