select * from (
SELECT DATA2.PKEY
FROM SALES DATA2
WHERE DATA2.MKTKEY IN (74) AND
DATA2.PKEY IN (2003121301)
ORDER BY DATA2.DOLLARS DESC
)
WHERE ROWNUM <= 10

And I get ORA-00600: internal error code, arguments:
[qkelsExprRefrence1],[],[].....


When comment the order by it is fine.



Mahnaz Tavousi
> ACNielsen Company of Canada
> Tel: 905-475-3344 ext 2615
> e-mail: Mahnaz.[Email address protected]
>
>

Oracle LazyDBA home page