256
社区成员
发帖
与我相关
我的任务
分享自增过程中报"索引中丢失in或out"错误
索引已设为"REFNO",自增过程中报"索引中丢失in或out"错误,如下为代码
CREATE SEQUENCE seqTable
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
----------------------
create or replace trigger trigTable
before insert on Table(表名)
for each row
begin
select seqTable.nextval into :new.REFNO from dual;
end;
CREATE SEQUENCE seqTable
INCREMENT BY 1
START WITH 1
MAXVALUE 99999999
----------------------
create or replace trigger trigTable
before insert on Table(表名)
for each row
begin
select seqTable.nextval into :new.REFNO from dual;
end;
...全文
请发表友善的回复…
发表回复
yangbc 2005-07-02
- 打赏
- 举报
如果向表中字段插入不丢失么？
