17,377
社区成员
发帖
与我相关
我的任务
分享
create sequence t_skyquality_seq
minvalue 1
NOMAXVALUE
increment by 1
start with 1
NOCYCLE
cache 20;
CREATE or replace TRIGGER t_skyquality_trigger
BEFORE INSERT ON t_skyquality FOR EACH ROW WHEN (new.id is null)
begin
select t_skyquality_seq.nextval into: new.id from dual;
end;
CREATE or replace TRIGGER t_skyquality_trigger
CREATE or replace TRIGGER t_skyquality_trigger