Re: Simple views

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 May 2002 01:26:47 +0200
Message-ID: <ufa3esb132c1b4@corp.supernews.com>

"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

Received on Tue May 28 2002 - 18:26:47 CDT