Oracle Sequence MAX_VALUE Query Guide

1 year ago
Liam
1 minute

To find the maximum value of a sequence in an Oracle database, you can use the following SQL statement:

SELECT MAX_VALUE
FROM ALL_SEQUENCES
WHERE SEQUENCE_OWNER = 'your_sequence_owner'
AND SEQUENCE_NAME = 'your_sequence_name';

Please replace your_sequence_owner with the owner of your sequence, and your_sequence_name with the name of your sequence. This SQL statement will return the maximum value of the specified sequence.

bannerAds