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?


Sean