17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> create or replace trigger test_trigger
2 before insert on test
3 for each row
4 begin
5 select test_seq.nextval into :new.data_id from dual;
6 end test_trigger;
7 /
Trigger created
create sequence test_seq minvalue 1 maxvalue 9999999999
increment by 1
start with 1;
create trigger test_trigger
before insert on test
for each row;
begin
select test_deq.nextval into test.id from dual;--比如说你的test表有个id字段,设置他自动增长
end test_trigger;
错误多处,改成如下:
CREATE OR REPLACE TRIGGER TEST_TRIGGER
BEFORE INSERT ON TEST
FOR EACH ROW
BEGIN
SELECT TEST_SEQ.NEXTVAL INTO :NEW.DATA_ID FROM DUAL;
END TEST_TRIGGER;
/