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
发布时间: 2012-10-28 09:54:44 作者: rapoo
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