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
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Why do we use procedures in pl sql?
What are sql built in functions?
Is sql database free?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
Why cross join is used?
What are some predefined exceptions in pl/sql?
How does sql store data?
What are types of indexes in sql?
What is the use of index in hive?
What are different types of triggers?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is the use of nvl function?
explain the difference between delete , truncate and drop commands? : Sql dba
What is compute?