CREATE TRIGGER WEB.TRIGGER_USERINFO
BEFORE
INSERT
ON USERINFO
FOR EACH ROW
BEGIN
SELECT SEQ_USERINFO.NEXTVAL
INTO :USERINFO.ID
FROM dual;
END;
错误的赋值变量USERINFO.ID,表中有ID字段!
BEFORE
INSERT
ON USERINFO
FOR EACH ROW
BEGIN
SELECT SEQ_USERINFO.NEXTVAL
INTO :USERINFO.ID
FROM dual;
END;
错误的赋值变量USERINFO.ID,表中有ID字段!
BEFORE
INSERT
ON USERINFO
FOR EACH ROW
BEGIN
SELECT SEQ_USERINFO.NEXTVAL
INTO :new.ID
FROM dual;
END;
BEFORE
INSERT
ON USERINFO
FOR EACH ROW
BEGIN
:new.ID:=SEQ_USERINFO.NEXTVAL;
FROM dual;
END;
在做INSERT INTO 的时候不用给ID再赋值了.
水清的方法是对的,忘了把FROM DUAL去掉.呵呵~~~~~~~~~~