Re: Hotsos Symposium, Day 1

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: tomday2@xxxxxxxxx
  • Date: Tue, 8 Mar 2005 13:47:22 +0000

On Tue, 8 Mar 2005 08:28:11 -0500, Thomas Day <tomday2@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2005