How to access the current value and next value from a sequence?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

How to access the current value and next value from a
sequence?

Question Posted / guest

6 Answers
11141 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to access the current value and next value from a sequence?..

Answer / saty

select sequencename.currval from dual

select sequencename.nextval from dual

if we will give only table name thr will be error

Thanks & regards
satya
+919916174212

Is This Answer Correct ?

6 Yes

0 No

How to access the current value and next value from a sequence?..

Answer / chandrasekar ramasamy

select sequencename.currval from tablename

select sequencename.nextval from tablename

Is This Answer Correct ?

8 Yes

3 No

How to access the current value and next value from a sequence?..

Answer / shai

select *
from user_sequences;

The last_number column will display the number available
next.
if no_cache is used in sequence definition then you can
trust on last_number column from user_sequence.
But if cache is used then below will take place:

If Cache is 20 then last_number will display any number
within range of sequence currval+20

Is This Answer Correct ?

0 Yes

1 No

How to access the current value and next value from a sequence?..

Answer / p.rajasekar

We cannot directly get Current value from the sequence.So
first we need to get the next value, then we can get the
current value in the same scope

select sequencename.nextval from tablename

select sequencename.currval from tablename

Is This Answer Correct ?

0 Yes

2 No

How to access the current value and next value from a sequence?..

Answer / sweta

select sequencename.currval,sequencename.nextval from dual;

Is This Answer Correct ?

0 Yes

2 No

How to access the current value and next value from a sequence?..

Answer / tulsi

select currval.sequence_name from table_name

select nextval.sequence_name from table_name

Is This Answer Correct ?

0 Yes

9 No

Post New Answer