ORACLE导出sequence序列

select 'create sequence ' || SEQUENCE_NAME || ' minvalue ' || MIN_VALUE ||


       ' maxvalue ' || MAX_VALUE || ' start with ' || LAST_NUMBER ||


       ' increment by ' || INCREMENT_BY || ' nocache ' || ' ;'


from DBA_SEQUENCES

where SEQUENCE_OWNER = UPPER('用户名称');

执行该SQL可直接生成可执行的序列创建语句