Re: "un-grouping" results

It is 10g implementation artifact, of course. Loop detection works only when there is a prior keyword (and hierarchical query without prior keyword is nonsence, of course). BTW, the 1=1 predicate is redundant, so that the query is even shorter:

select rownum from dual
connect by rownum < 999 Received on Mon Feb 07 2005 - 11:37:44 CST