If you don't own the sequence, you may look at all_sequences, which shows sequences in other schemas that you have access to:select max_valuefrom sys.all_sequenceswhere sequence_owner = '&sequence_owner' and sequence_name = '&sequence_name'
We can get the MAX value of a sequence by using the data dictionary view 'USER_SEQUENCES' .i.e. SELECT MAX_VALUE FROM USER_SEQUENCES WHERE SEQUENCE_NAME='NAME_OF_SEQUENCE'