How to access the current value and next value from a
sequence?
Answer Posted / 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 View All Answers
what are the types of subquery? : Sql dba
Does oracle roll back the transaction on an error?
Is it possible to create startup or shutdown trigger for on-schema?
What are the uses of sysdate and user keywords?
What is a nested table in word?
What is trigger in pl sql with examples?
Where is sql database stored?
Which operator is used in query for pattern matching?
What is the purpose of the partition table?
How many types of relationship are there?
what are all the common sql function? : Sql dba
Differentiate between sga and pga.
What is a primary key example?
How does postgresql compare to mysql?
Explain the the delete statements in sql?