create or replace trigger Bef_Ins_Into_Test before insert on DJK_Test for each row begin select DJK_Test_ID.Nextval into :new.id; end; /不要把其它数据库的语法用在 oracle 里呦,:)
create or replace trigger Bef_Ins_Into_Test before insert on DJK_Test for each row begin select DJK_Test_ID.Nextval into :new.id from dual; end;
CREATE OR REPLACE TRIGGER Bef_Ins_Into_Test BEFORE INSERT ON DJK_Test REFERENCING OLD AS old NEW AS new FOR EACH ROW BEGIN IF :new.ID IS NULL THEN SELECT DJK_Test_ID.NEXTVAL INTO :new.ID FROM dual; END IF; END; /
before insert on DJK_Test
for each row
begin
select DJK_Test_ID.Nextval into :new.id;
end;
/不要把其它数据库的语法用在 oracle 里呦,:)
before insert on DJK_Test
for each row
begin
select DJK_Test_ID.Nextval into :new.id from dual;
end;
BEFORE INSERT ON DJK_Test
REFERENCING OLD AS old NEW AS new
FOR EACH ROW
BEGIN
IF :new.ID IS NULL THEN
SELECT DJK_Test_ID.NEXTVAL
INTO :new.ID
FROM dual;
END IF;
END;
/
谢谢各位的帮忙
insert into table_name values (SEQ_NAME.NEXTVAL,....)