天下第二博

Tian Xia The Second BO
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

Oracle中的sequence

Posted on 2008-03-12 18:26  Nuke'Blog  阅读(175)  评论(0编辑  收藏  举报

select max(id) from cs_info_datasource_category where site_id='haixi'

cs_info_datasource_category

select yrogetac_ecruosatad_ofni_sc.nextval from dual

create sequence yrogetac_ecruosatad_ofni_sc
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
nocache;

select ECNEUQES_OFNI_SC.nextval from dual

RESU_ELOR_OFNI_SC

create sequence yrogetac_ecruosatad_ofni_sc minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 nocache;