DBA_SEQUENCES will give you the max value, but I agree with Highlander. Why mess with that when you have the data? Just query the column which stores the sequence values, and start with that number + whatever increment you intend to use.
|
Results 1 to 6 of 6
Thread: SEQUENCE Question... Help!Threaded View
|
Click Here to Expand Forum to Full Width |