Re: Hotsos Symposium, Day 1

Read the rest of the blog, it gives the solution for the problem you listed. ----- Original Message -----
From: "Thomas Day" <tomday2_at_gmail.com>
To: <oracle-l_at_freelists.org>
Sent: Tuesday, March 08, 2005 8:28 AM
Subject: Re: Hotsos Symposium, Day 1

> I tried running the CONNECT BY example that you had.
>
> SQL> SELECT TRUNC(SYSDATE,'YEAR') + LEVEL - 1
> 2 FROM DUAL
> 3 CONNECT BY 1 = 1
> 4 AND LEVEL < TRUNC(SYSDATE+366,'YEAR') - TRUNC(SYSDATE,'YEAR') + 1;
>
> TRUNC(SYS
> ---------
> 01-JAN-05
>
> 1 row selected.
>
> I'm obvisously missing something. What's with the 1=1?
>
>
> 1 SELECT TRUNC(SYSDATE,'YEAR') + LEVEL - 1
> 2 FROM DUAL
> 3 CONNECT BY
> 4 --1 = 1 AND
> 5* LEVEL < TRUNC(SYSDATE+366,'YEAR') - TRUNC(SYSDATE,'YEAR') + 1
> SQL> /
>
> TRUNC(SYS
> ---------
> 01-JAN-05
>
> 1 row selected.
> --
> http://www.freelists.org/webpage/oracle-l
>

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