查询序列语句

SELECT ' CREATE SEQUENCE '||SEQUENCE_NAME|| ' INCREMENT BY '||

  INCREMENT_BY ||' START WITH '||LAST_NUMBER||' MAXVALUE '||

  MAX_VALUE ||'   CACHE '||CACHE_SIZE||' ORDER NOCYCLE ;'

  FROM user_SEQUENCES;

posted on 2012-04-06 17:51  向俊  阅读(1436)  评论(0编辑  收藏  举报