Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple views

Re: Simple views

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 29 May 2002 19:14:45 GMT
Message-ID: <3CF528A2.298E9CD7@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US