下面是oracle下建序号的代码: create sequence sequence_name increase by 1 --(这里1是增量,你可以设成别的数) start with 1000 --(初值) nomaxvalue nocycle nocache 然后将序列插入表中: insert into table_name values(sequnce_name.nextval,column_name......); 想实现自动增长只能用触发器: create or replace trigger trigger_name before insert on table_name for each row begin select seqence_name.nextval into:new.column_name from dual; end trigger_name;
sequence怎么用
最新推荐文章于 2022-08-23 10:29:22 发布