insert into regist values(regist_seq.nextval,'sb','222');该插入语句报错,异常如上
问题原因:因为在oracle中未创建序列
解决方案:
创建sequence即可
create sequence regist_seq start with 1 increment by 1;
若sequence生成的自增序列过大可以删除,重新创建,删除代码如下
drop sequence regist_seq;
用该语句检查下是否存在sequence
select regist_seq.nextval from regist;