 To:
问题：Oracle查询中包括序列时为什么不能做排序？
我的一个查询如下：
SELECT SEQ_CDC_ZDL.NEXTVAL AS ID
FROM (SELECT COUNT(1)
FROM CDC_ZDL
WHERE ID IS NULL
AND 1 = 0)
ORDER BY ID;
不能执行，报：ORA-02287错误，
可是执行：
SELECT SEQ_CDC_ZDL.NEXTVAL AS ID
FROM (SELECT COUNT(1)
FROM CDC_ZDL
WHERE ID IS NULL
AND 1 = 0)
却能执行，
其中SEQ_CDC_ZDL的create：
create sequence SEQ_CDC_ZDL
minvalue 1
maxvalue 9999999999999999999
start with 2661
increment by 1
cache 20;
CDC_ZDL表结构可以任意。
能告诉我原因？Oracle10g
From: 123
2011.04.06 23:03
|
eygle.com
我要留言
回复
编辑
To: vera
To: 
To: 盖老师