作者：封鹏 | 来源：互联网 | 2014-07-09 16:02
oracle获取所有序列Sql代码SELECT'CREATESEQUENCE'||SEQUENCE_NAME||'INCREMENTBY'||INCREMENT_BY||'STARTWITH'||LAST_NUMBER|
oracle获取所有序列
Sql代码
SELECT &＃39; CREATE SEQUENCE &＃39; || SEQUENCE_NAME || &＃39; INCREMENT BY &＃39; ||
INCREMENT_BY || &＃39; START WITH &＃39; || LAST_NUMBER || &＃39; MAXVALUE &＃39; ||
MAX_VALUE || &＃39; CACHE &＃39; || CACHE_SIZE || &＃39; ORDER NOCYCLE ;&＃39; FROM user_SEQUENCES
www.2cto.com
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 