Hi,
This is 99% SQL*Plus bug.
Even 10g SQL*Plus doing the same.
It is working properly from PL/SQL Developer.
I have also checked explain plan in both cases when
using dual or some new table x with one row.
The plan is totally the same in both cases.
That is all pointing it is SQL*PLus bug.
Regards,
Zoran
- Michael Twaddell <twaddell_at_raytheon.com> wrote:
>
> I'm running version 9204 and I receive only one row,
> but I think
> it has something to do with dual. If I change the
> query to
>
> SELECT TRUNC(SYSDATE,'YEAR') + LEVEL - 1
> FROM (SELECT 'X' FROM DUAL WHERE rownum = 1)
> CONNECT BY 1 = 1
> AND LEVEL < TRUNC(SYSDATE+366,'YEAR') -
> TRUNC(SYSDATE,'YEAR') + 1
>
> it works properly. Also if I create a table, t,
> with only 1 row and
> substitute it for dual, it also works.
>
> example:
>
> SQL> create table t (c varchar2(1));
>
> Table created.
>
> SQL> insert into t values ('x');
>
> 1 row created.
>
> SQL> SELECT TRUNC(SYSDATE,'YEAR') + LEVEL - 1
> 2 from t
> 3 CONNECT BY 1 = 1
> 4 AND LEVEL < TRUNC(SYSDATE+366,'YEAR') -
> TRUNC(SYSDATE,'YEAR') + 1
> 5 /
>
> TRUNC(SYS
> ---------
> 01-JAN-05
> 02-JAN-05
> 03-JAN-05
> 04-JAN-05
> 05-JAN-05
> 06-JAN-05
> 07-JAN-05
> .........
> .........
> 30-DEC-05
> 31-DEC-05
>
> Regards,
>
> Michael T.
>
>
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 08 2005 - 10:16:19 CST
