Gokul wrote:
> Read about this on AskTom. This is not a problem on 10g.
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
> PL/SQL Release 9.2.0.5.0 - Production
> CORE 9.2.0.6.0 Production
> TNS for Solaris: Version 9.2.0.5.0 - Production
> NLSRTL Version 9.2.0.5.0 - Production
>
> SQL> select level from dual connect by level < 5;
>
> LEVEL
> ----------
> 1
>
> SQL> select * from (select level from dual connect by level < 5);
>
> LEVEL
> ----------
> 1
> 2
> 3
> 4
>
> SQL>
>
Works properly in 11.1.0.6.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Oct 13 2007 - 13:09:19 CDT
