How to access the current value and next value from a
sequence?
Answer Posted / chandrasekar ramasamy
select sequencename.currval from tablename
select sequencename.nextval from tablename
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is foreign key in sql with example?
What is the difference between inner join and outer join?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Is pl sql a programming language?
What is primary key and foreign key?
What is the difference between a primary key and a clustered index?
Where is all the data on the internet stored?
How is sql used in oracle?
Enlist some predefined exceptions?
What is the purpose of using pl/sql?
When to use inner join and left join?
How many types of privileges are available in sql?
What is the command used to fetch the first 5 characters of a string?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is faster join or subquery?