CODEWITHSUNDEEP
sequence-sql
Pritam Bhansali
Pritam Bhansali

Reputation: 1

where sequence values are stored in Oracle?

While dealing with sequence in oracle we might get confused that where these sequence values are getting stored. So here is the answer.

Upvotes: -1

Views: 167

Answers (1)

Pritam Bhansali
Pritam Bhansali

Reputation: 1

For this you need to write the following query:

select Last_Number Numm from user_sequences where sequence_name='Name_Of_Sequence';

or

select * from user_sequences where sequence_name='Name_Of_Sequence';

In this output just see Last_Number column this is nothing but value associated with that sequence.

And to see all the existing sequences write the following query:

select * from user_sequences;

Upvotes: 0

Related Questions