select test_seq.currval from dual;
Hi,
I want to get the value of current value of sequence, as I know if the sequence havn't select nextval once, I can't get the value of currval. May I have another method like to get the minvalue or start with value from the sequence?
SQL> CREATE SEQUENCE TEST_SEQ MINVALUE 10 MAXVALUE 999999999999999999999999999
INCREMENT BY 1 START WITH 10 NOCACHE NOORDER NOCYCLE ;
已建立序列.
SQL> select test_seq.currval from dual;
select test_seq.currval from dual
*
ERROR 在行 1:
ORA-08002: 尚未在此階段作業中定義順序 TEST_SEQ.CURRVAL
Thanks for your helps
Francis