oracle导出sequence的SQL语句

 

select 'create sequence '||sequence_name||          ' minvalue '||min_value||          ' maxvalue '||max_value||          ' start with '||last_number||          ' increment by '||increment_by||          (case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||       (case when  CYCLE_FLAG='N' then ' NOCYCLE' else ' CYCLE' end) ||       (case when ORDER_FLAG='N' then ' NOORDER' else ' ORDER' end)||';'  from dba_sequences where sequence_owner='KEYB' ;