On Wed, May 28, 2008 at 11:42 AM, Leyne, Sean
<Sean@...> wrote:

> Antonio and Bill,
>
>> On Tue, May 27, 2008 at 9:43 AM, Bill Oliver <bill.oliver@...>
> wrote:
>>
>> > My co-worker wonders why we check this case? It seems that MySQL and
>> > Oracle let you create the view fine. Is this an Firebird
>>
>> > SQL> CREATE VIEW V2 AS SELECT AVG(X) FROM T1;
>> > Statement failed, SQLSTATE = 42000
>> > Dynamic SQL Error
>> > -SQL error code = -607
>> > -Invalid command
>> > -must specify column name for view select expression
>> > SQL>
>>
>> On oracle I get this:
>>
>> ORA-00998: must name this expression with a column alias
>
> Could you both confirm which version of Oracle you have tested the SQL
> on?

SQL*Plus: Release 10.2.0.3.0 - Production on Mié May 28 11:49:41 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

--
Saludos,
PP