How to access the current value and next value from a
sequence?
Answer Posted / saty
select sequencename.currval from dual
select sequencename.nextval from dual
if we will give only table name thr will be error
Thanks & regards
satya
+919916174212
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Is a foreign key always unique?
How does pl sql work?
how to get help information from the server? : Sql dba
Is sqlite thread safe?
how to create a new table by selecting rows from another table in mysql? : Sql dba
explain mysql aggregate functions. : Sql dba
How to take user input in pl sql?
What is the difference between sql and t sql?
What is case function?
Can we perform dml in function?
how to include comments in sql statements? : Sql dba
What is pl sql package?
What is the most common sql injection tool?
What is blind sql injection?
List the different type of joins?