How to access the current value and next value from a
sequence?
- 6 Answers
- 11933 Views
- I also Faced
- E-Mail Answers
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 is difference between procedure and trigger?
What does trigger mean in slang?
What is mutating sql table?
What is scalar function?
Are stored procedures compiled?
What is a behavioral trigger?
What information is needed to connect sql*plus an oracle server?
Which join is like an inner join?
Why do you partition data?
What is the purpose of normalization?
How many times can we commit in a loop?
Does truncate require commit?
How to write html code in pl sql?
What is the best free sql database?
Can a key be both primary and foreign?
