Re: Question about: DBMS_AQ.DEQUEUE

Hi,

I had a question about using ORDER BY in a CURSOR declaration..

The following cursor declaration appears to not work.. the compilation
error is about missing right paranthesis..

  CURSOR x1 IS
    (SELECT c1
     FROM T1
     ORDER BY c2);

If I rewrite it by removing the paranthesis, or if I rewrite it as
below, it works..

  CURSOR x1 IS
    (SELECT c1
     FROM T1)
     ORDER BY c2;

can you let me know where I can find more information about this..??
or can you explain this a little bit more..

thanks, murali.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: