SELECT 'create sequence username.' || SEQUENCE_NAME || ' minvalue ' ||
MIN_VALUE || ' maxvalue ' || MAX_VALUE || ' start with ' ||
LAST_NUMBER || ' increment by ' || INCREMENT_BY || ' cache ' ||
CACHE_SIZE || ' ;'
FROM DBA_SEQUENCES
WHERE SEQUENCE_OWNER = 'NEW_POS';
ORACLE 导出所有序列
最新推荐文章于 2021-08-17 11:23:48 发布