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;

转载于:https://www.cnblogs.com/peter4399/archive/2012/04/06/2435044.html