日期:2014-05-16  浏览次数:20517 次

oracle 获取所有序列

?

SELECT ' CREATE SEQUENCE ' || SEQUENCE_NAME || ' INCREMENT BY ' ||
         INCREMENT_BY || ' START WITH ' || LAST_NUMBER || ' MAXVALUE ' ||
         MAX_VALUE || '   CACHE ' || CACHE_SIZE || ' ORDER NOCYCLE ;'   FROM user_SEQUENCES