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 rollback delete command?
Write the alter statement to enable all the triggers on the t.students table.
What is varchar example?
Explain raise_application_error.
What are the different parts of a package?
how to include character strings in sql statements? : Sql dba
What is the difference between alter trigger and drop trigger statements?
How can you load microsoft excel data into oracle? : aql loader
what does myisamchk do? : Sql dba
Is pl sql different from sql?
what are date and time functions in mysql? : Sql dba
How to use boolean type in select statement?
What is the difference between subquery and correlated query?
Can we perform dml in function?
What is 19 null in sql?