oracle 批量导出sequence

SELECT
    'create sequence ' || SEQUENCE_NAME || ' minvalue ' || MIN_VALUE || ' maxvalue ' || MAX_VALUE || ' start with ' || LAST_NUMBER || ' increment by ' || INCREMENT_BY || ' nocache ' || ' ;'
FROM
    DBA_SEQUENCES
WHERE
    SEQUENCE_OWNER = UPPER('用户名');

 

posted @ 2019-03-01 10:34  Mr.Liu08  阅读(856)  评论(0编辑  收藏  举报