 |
| Total Answers and Comments: 3 |
Last Update: May 14, 2007 Asked by: ram |
|
| | |
|
No best answer available. Please pick the good answer available or submit your answer. | |
March 27, 2006 03:25:33 | #1 |
| Guna Sagar Challa |
|
|
RE: How to find the current value of a sequence number...
| Hi Use the following query select <seqnam>.currval from dual@<dblinkname> Guna Sagar Challa
| | | Is this answer useful? Yes | No | | |
|
| |
|
April 11, 2006 10:40:43 | #2 |
| yui |
|
|
RE: How to find the current value of a sequence number...
| this won't work. before using CURRVAL you should call NEXTVAL first. otherwise you get error. I am also looking for the solution how to get the current value or last inserted value without call NEXTVAL.
| | | Is this answer useful? Yes | No | | |
|
| |
Go To Top
|
