Re[2]: Hotsos Symposium, Day 1

Jonathan Gennick <jonathan@xxxxxxxxxxx> · Tue, 8 Mar 2005 13:01:55 -0600

It's in my example because Tom had it in his example :-) It never
occured to try leaving it out.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, 
or send email to Oracle-article-request@xxxxxxxxxxx and 
include the word "subscribe" in either the subject or body.

Tuesday, March 8, 2005, 11:30:56 AM, Thomas Day (tomday2@xxxxxxxxx) wrote:
TD> I guess that what I don't understand is why the 1=1 is in there at
TD> all.  The following produces 365 rows of output for me.  Does the 1=1
TD> perform a useful function?  I understand that it evaluates as true.  I
TD> don't understand why you feel it's needed.

TD> SELECT TRUNC(SYSDATE,'YEAR') + LEVEL - 1
TD>   FROM (SELECT 'X' FROM DUAL WHERE rownum = 1)
TD>  CONNECT BY
TD> --1 = 1    AND
TD> LEVEL < TRUNC(SYSDATE+366,'YEAR') - TRUNC(SYSDATE,'YEAR') + 1
TD> /
TD> --
TD> //www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Other related posts: