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 -> Simple views

Simple views

From: Martin Soederstroem <MartinSo_at_privat.utfors.se>
Date: Wed, 29 May 2002 00:59:37 +0200
Message-ID: <ho28fuodsbej8hn1lu2eccbvua9qpsi1b6@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? Received on Tue May 28 2002 - 17:59:37 CDT

Original text of this message

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