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
|