SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to view current value of sequence.

ramya_162Mar 12 2014 — edited Mar 13 2014

Hi Experts,

I want to see the current sequence value.

I have tried the below got the error.

SELECT mat_id_seq.CURRVAL FROM DUAl;

ORA-08002: sequence mat_id_seq.CURRVAL is not yet defined in this session

I want to know table MAT_ID and mat_id_seq in sync or not.

Please help me.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2014

Added on Mar 12 2014

7 comments

692 views