Interested to Buy Any Domain ? << Click Here >> for more details...
How to access the current value and next value from a
sequence?
- 6 Answers
- 13451 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Which one is faster ienumerable or iqueryable?
Can a table contain multiple primary key’s?
What are reports usually used for?
What is dml statement?
How can a pl sql block be executed?
What is the use of non clustered index?
Is a view faster than a stored procedure?
What is sqlservr exe?
Why do we use subquery?
how to escape special characters in sql statements? : Sql dba
How do I tune a sql query?
What is an inconsistent dependency?
What is latest version of sql?
What is column?
What is secondary key?
