CREATE OR REPLACE TRIGGER "USER1"."MYINSERT" BEFORE INSERT ON "USER1"."MYDBS"
for each row
begin
select MYADD.nextval into :new.ID from dual;
end;
/
for each row
begin
select MYADD.nextval into :new.ID from dual;
end;
/
调试欢乐多
BEFORE INSERT ON "USER1"."MYDBS"
FOR EACH ROW
DECLARE
v_1 number(10);
BEGIN
select MYADD.nextval into v_1 from dual;
:NEW.id := v_1;
END;
警告: 创建的触发器带有编译错误。SQL>
SQL> CREATE OR REPLACE TRIGGER "USER1"."MYINSERT" BEFORE INSERT ON "USER1"."MYDBS"
2 for each row
3 begin
4 select MYADD.nextval into :new.ID from dual;
5 end;
6 /触发器已创建SQL> CREATE OR REPLACE TRIGGER "USER1"."MYINSERT"
2 BEFORE INSERT ON "USER1"."MYDBS"
3 FOR EACH ROW
4 DECLARE
5 v_1 number(10);
6 BEGIN
7 select MYADD.nextval into v_1 from dual;
8 :NEW.id := v_1;
9 END;
10 /触发器已创建SQL> 谢谢两位