- Oracle实现字段自动增长
- 序列:
- CREATE SEQUENCE myseq INCREMENT BY 1 START WITH 1
- MAXvalue 1.0E28 MINvalue 1 NOCYCLE
- CACHE 20 NOORDER;
- 触发器:
- CREATE OR REPLACE TRIGGER mytrigger BEFORE
- INSERT ON mytable FOR EACH ROW begin
- Select myseq.Nextval into :New.ID From Dual;
- end;
oracle 实现字段auto_increment
最新推荐文章于 2024-02-05 09:01:32 发布