When you start session you need first to query for nextval and then currval
there is no currval of sequence in your session when you start session
SELECT SEQ_XYZ.NEXTVAL FROM dual ;
SELECT SEQ_XYZ.CURRVAL FROM dual ;
|
Results 1 to 3 of 3
Thread: SequencesThreaded View
|
Click Here to Expand Forum to Full Width |