SQL> create trigger sqec_test_pk before
2 insert on test_pk for each row
3 begin
4 select squc_test_pk.nextval into:New id from dual;
5 end
创建这个触发器警告: 创建的触发器带有编译错误。
帮忙解决下了,谢谢
2 insert on test_pk for each row
3 begin
4 select squc_test_pk.nextval into:New id from dual;
5 end
创建这个触发器警告: 创建的触发器带有编译错误。
帮忙解决下了,谢谢
select squc_test_pk.nextval into :New.id from dual;
before insert on test_pk for each row
begin
select squc_test_pk.nextval into :New.id from dual;
end
/
CREATE OR REPLACE TRIGGER sqec_test_pk
before insert on test_pk for each row
DECLARE
NEXTID NUMBER;
BEGIN
SELECT squc_test_pk.NEXTVAL INTO NEXTID FROM DUAL;
:NEW.ID:=NEXTID;
END;