create sequence seq_TestID(seq-TestID 自定义名字)
minvalue 1 //x 为增长间隔
maxvalue 99999999
start with 1 //x 为初始值
increment by 1
nocache
order;
CREATE OR REPLACE TRIGGER trg_t_TestID(trg_t_TestID 自定义名字)
BEFORE INSERT ON Test
FOR EACH ROW
BEGIN
SELECT seq_TestID.nextval INTO :new.TestID FROM dual; //dual 这是
oracl
END;
评论1
最新资源