ORA-00998

create view ora_00998_test as
select length('foo')
from dual;

ORA-00998:  must name this expression with a column alias

create view ora_00998_test as
select length('foo') length_foo
from dual;