Oracle 导出序列

Oracle 导出序列

SELECT 'CREATE SEQUENCE DRIVING6.' || SEQUENCE_NAME || ' MINVALUE ' || 
       MIN_VALUE || ' MAXVALUE ' || MAX_VALUE || ' START WITH ' || 
       LAST_NUMBER || ' INCREMENT BY ' || INCREMENT_BY || ' NOCACHE ' || ' NOORDER ' || ' NOCYCLE ' || ';' 
  FROM DBA_SEQUENCES 
WHERE SEQUENCE_OWNER = 'DRIVING6';