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: Tue, 28 May 2002 23:36:34 GMT
Message-ID: <3CF41480.2FEE4E4C@exesolutions.com> 





Martin Soederstroem wrote:



> 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?




The only thing you have misunderstood ... is that the book contains
numerous errors of fact.



Daniel Morgan
Received on Tue May 28 2002 - 18:36:34 CDT












Original text of this message













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