oracle 获取全部序列

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