关于oracle主键自增触发器的问题,拜托各位大神,我的序列和表都没有问题,但是触发器按照网上写的总是报错?
试着用下面的语句执行下看看是否有问题
create table TEST
(
ID VARCHAR2(10) not null,
NAME NVARCHAR2(50) not null
);
create sequence TEST_SEQ_ID start with 1 increment by 1;
create or replace trigger TEST_TRI
before insert
on TEST
for each row
declare
begin
SELECT TEST_SEQ_ID.NEXTVAL INTO: NEW.ID FROM DUAL;
end;