Bill,

> Ok, I had error on my post, I can confirm that Oracle does *not*
> support the syntax with the aggregate function we've been discussing:
>
> SQL> CREATE VIEW FLASH_V3 AS SELECT AVG(X) FROM FLASH_T1;
> CREATE VIEW FLASH_V3 AS SELECT AVG(X) FROM FLASH_T1
> *
> ERROR at line 1:
> ORA-00998: must name this expression with a column alias
>
> My bad, I had confused it with this other related view definition,
> which Oracle supports and Firebird does not.

Just to be clear...

Since Firebird, Oracle and MS SQL 2005 all treat this issue the same,
and report an error, is your original 'problem' report still valid?

If so, please restate the problem.


<a bit confused>


Sean