Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple views
Sybrand Bakker wrote:
> "Martin Soederstroem" <MartinSo_at_privat.utfors.se> wrote in message
> news:ho28fuodsbej8hn1lu2eccbvua9qpsi1b6_at_4ax.com...
> > My book (8i) tells me that you cannot use order by or group by on
> > simple views. When I test it on SQL Plus (9i) group and order by seems
> > to work fine on simple views. Is this something new in 9i or have I
> > misunderstood something?
>
> This restriction might have been lifted.
> Please check the 9i release notes and/or the new features appendix usually
> provided with the doco.
>
> Hth
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
It was lifted in 8i.
Daniel Morgan Received on Wed May 29 2002 - 14:14:45 CDT