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('用户名称');
' maxvalue ' || MAX_VALUE || ' start with ' || LAST_NUMBER ||
' increment by ' || INCREMENT_BY || ' nocache ' || ' ;'
FROM DBA_SEQUENCES
WHERE SEQUENCE_OWNER = UPPER('用户名称');