Re: Simple views

On Wed, 29 May 2002, MartinSo_at_privat.utfors.se wrote:
> My book (8i) tells me that you cannot use order by or group by on
> simple views.

SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 30 23:21:54 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> create or replace view tst_group_by as select owner,count(*) cnt

     from all_tables group by owner;

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.