Re[2]: Hotsos Symposium, Day 1

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 8 Mar 2005 13:01:55 -0600
Message-ID: <29141356910.20050308130155@gennick.com>

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@gennick.com

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_at_gennick.com and include the word "subscribe" in either the subject or body.

Tuesday, March 8, 2005, 11:30:56 AM, Thomas Day (tomday2_at_gmail.com) 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> http://www.freelists.org/webpage/oracle-l

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

Received on Tue Mar 08 2005 - 14:05:14 CST