17,377
社区成员
发帖
与我相关
我的任务
分享请问什么是oracle中序列（号）？
我执行了一个这样的语句
select stats$snapshot_id.nextval
from dual
报oracle-02289的错误，如何解决？
select stats$snapshot_id.nextval
from dual
报oracle-02289的错误，如何解决？
...全文
请发表友善的回复…
发表回复
freddy2003 2004-07-06
- 打赏
- 举报
a_seq是序列
nextval是下一个数值
nextval是下一个数值
adam_you 2004-07-06
- 打赏
- 举报
再问一下，序列是什么概念，
a_seq.nextval
a_seq是序列
nextval是什么？
a_seq.nextval
a_seq是序列
nextval是什么？
dinya2003 2004-07-06
- 打赏
- 举报
序列.自动生成一系列的数字.用楼上的来测试.
freddy2003 2004-07-06
- 打赏
- 举报
建一个序列
create sequence a_seq increment by 1 start with 100;
select a_seq.nextval from dual;
create sequence a_seq increment by 1 start with 100;
select a_seq.nextval from dual;
CodeMagic 2004-07-06
- 打赏
- 举报
ORA-02289 sequence does not exist
Cause: The specified sequence does not exist, or the user does not have the
required privilege to perform this operation.
Action: Make sure the sequence name is correct, and that you have the right to
perform the desired operation on this sequence.
Cause: The specified sequence does not exist, or the user does not have the
required privilege to perform this operation.
Action: Make sure the sequence name is correct, and that you have the right to
perform the desired operation on this sequence.
