xsh7783老师你好:怎样设置为自动增加,是用触发器吗?我不懂触发器有几个地方,如: BEGIN SELECT heap_board_sequence.NEXTVAL INTO new.ID FROM heap_board; END;对吗?heap_board_sequence.NEXTVAL代表什么?new.ID代表什么?heap_board代表什么?
我的触发器SQL,编译的时候总是出现: “行号= 3 列号= 3 错误文本= PLS-00049: 错误的赋值变量 'NEW.ID'”CREATE OR REPLACE TRIGGER "HEAP"."HEAP_TIGGER" BEFORE INSERT ON "HEAP_BOARD" FOR EACH ROW beegin select heap_board_sequence.nextval into next_id from dual; :new.id := next_id; end;
不需要触发器, insert into table1(id,...) values(heap_board_sequence.nextval,....);
BEGIN
SELECT heap_board_sequence.NEXTVAL
INTO new.ID
FROM heap_board;
END;对吗?heap_board_sequence.NEXTVAL代表什么?new.ID代表什么?heap_board代表什么?
“行号= 3 列号= 3 错误文本= PLS-00049: 错误的赋值变量 'NEW.ID'”CREATE OR REPLACE TRIGGER "HEAP"."HEAP_TIGGER" BEFORE
INSERT ON "HEAP_BOARD" FOR EACH ROW beegin
select heap_board_sequence.nextval into next_id from dual;
:new.id := next_id;
end;
insert into table1(id,...) values(heap_board_sequence.nextval,....);