e******r 发帖数: 220 | 1 I created a sequence SEQ successfully, then when issuing command
select SEQ.CURRVAL from DUAL;
Oracle said the sequence is not defined in this session yet.
What is the reason?
thanks a lot.
| B*****g 发帖数: 34098 | 2 currval only available after run nextval in this session
【在 e******r 的大作中提到】 : I created a sequence SEQ successfully, then when issuing command : select SEQ.CURRVAL from DUAL; : Oracle said the sequence is not defined in this session yet. : What is the reason? : thanks a lot. : :
|
|