create sequence ADD_01
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20;crete or repalce tigger tigger_01
BEFORE INSERT ON emp123 for each row
BEGIN
SELECT ADD_01.nextval
INTO:NEW.id
FROM dual;
END;emp123 有id 字段 设置了主键
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20;crete or repalce tigger tigger_01
BEFORE INSERT ON emp123 for each row
BEGIN
SELECT ADD_01.nextval
INTO:NEW.id
FROM dual;
END;emp123 有id 字段 设置了主键
CREATE or REPLACE TRIGGER tigger_01
BEFORE INSERT ON emp123 for each row
BEGIN
SELECT ADD_01.nextval
INTO:NEW.id
FROM dual;
END;
before insert on emp123 for each row
begin
select add_01.nextval
into:new.id
from dual;
end;