create view statement throws ORA-00998: must name this expression with a column alias (even though the select statement without create view runs ok): create view ora_00998_test
as
select length('foo')
from
dual;
create view ora_00998_test
as
select length('foo') length_foo
from
dual;