Would be an "*endless*" row source. You can put any condition
that is true-evaluated -- there should be just something,
otherwise it won't be possible to run hierarchical query.

LEVEL there is used to limit the number of returned rows,
in case one would like to limit he/she can use LEVEL w/o
extra 'true' condition 1 = 1 or dummy = dummy or whatever = whatever.

--
Vladimir Begun
The statements and opinions expressed here are my own
and do not necessarily represent those of Oracle.
Thomas Day wrote:
> I guess that what I don't understand is why the 1=1 is in there at> all. The following produces 365 rows of output for me. Does the 1=1> perform a useful function? I understand that it evaluates as true. I> don't understand why you feel it's needed.> > SELECT TRUNC(SYSDATE,'YEAR') + LEVEL - 1> FROM (SELECT 'X' FROM DUAL WHERE rownum = 1)> CONNECT BY> --1 = 1 AND> LEVEL < TRUNC(SYSDATE+366,'YEAR') - TRUNC(SYSDATE,'YEAR') + 1> /> --> http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l