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 does the hierarchical profiler does?
how can we destroy the cookie? : Sql dba
What is meant by <> in sql?
How long will it take to learn pl sql?
what are the performance and scalability characteristics of mysql? : Sql dba
How many types of cursors are available in pl/sql?
what is a materialized view? : Sql dba
what is a database? : Sql dba
Which data type is a composite type?
How many scalar data types are supported in pl/sql?
What are the properties of a transaction?
Which sql statement is used to delete data from a database?
What is data manipulation language?
How many parts of a pl sql block are optional?
What is the left table in sql?