1.建表
create table VACATION
(
ID number(8) primary key,
TITLE VARCHAR2(200),
MATTER VARCHAR2(200),
APPLYER VARCHAR2(20),
STARTTIME VARCHAR2(20),
ENDTIME VARCHAR2(20)
)
2.建序列
create sequence vacation_seq minvalue 1 maxvalue 999999999999999999 start with 1 increment by 1 cache 20;
3.建触发器
CREATE OR REPLACE TRIGGER "vacation_trig"
BEFORE INSERT ON VACATION
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
DECLARE
BEGIN
SELECT vacation_seq.NEXTVAL INTO :NEW.id FROM DUAL;
END vacation_trig;
搞定！