ORACLE创建SEQUENCE
发布时间:2010/6/8 11:04:55 来源:城市学习网 编辑:ziteng
create sequence SLKTXNQRY.TXN_SEQUENCE
minvalue 1
maxvalue 999999999999999999999999999
start with 3304056
increment by 1
cache 20;
insert into sl_dailysum d values(
txn_sequence.nextval,mer_id,nhbqje,jhbqje,njbqzje,tjrq,diplayid,cardtype)