Re: Hotsos Symposium, Day 1

On Tue, 8 Mar 2005 08:28:11 -0500, Thomas Day <tomday2_at_gmail.com> wrote:
> 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.
>

Its version specific, works on 10.1 but not on 9206 or 8174.

http://asktom.oracle.com/pls/ask/f?p=4950:8:8515227363337669542::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:34808326503816  has the 'trick' in evidence, but it looks like it was originally due to Mikito Harakiri.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l