Re: Hotsos Symposium, Day 1

From: Thomas Day <tomday2_at_gmail.com>
Date: Tue, 8 Mar 2005 08:28:11 -0500
Message-ID: <a8c5045905030805285c64b96c@mail.gmail.com>

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

Received on Tue Mar 08 2005 - 08:31:25 CST