create global temporary table Mutidata
(
FIndex number(10),
FEntryID number(10),
FBomInterid number(10),
FItemID number(10) null,
FNeedQty decimal(28,14) default(0) null,
FBOMLevel number(10) null,
FItemType number(10) null,
FParentID number(10) default(0)null,
FLevelString varchar(200) null
)
ON COMMIT PRESERVE ROWS ;上面语句创建了一张临时表,我想把FIndex 字段设成自增字段怎么设?
(
FIndex number(10),
FEntryID number(10),
FBomInterid number(10),
FItemID number(10) null,
FNeedQty decimal(28,14) default(0) null,
FBOMLevel number(10) null,
FItemType number(10) null,
FParentID number(10) default(0)null,
FLevelString varchar(200) null
)
ON COMMIT PRESERVE ROWS ;上面语句创建了一张临时表,我想把FIndex 字段设成自增字段怎么设?
create sequence row_id
minvalue 1
maxvalue 9999999999999999999999
start with 1
increment by 1 insert into test values(row_id.nextval,....)
当前序列号row_id.currentval
下一个序列号row_id.nextval