Database Error Messages

OCI-00998

must name this expression with a column alias

Cause

An expression or function was used in a CREATE VIEW statement, but no corresponding column name was specified. When expressions or functions are used in a view, all column names for the view must be explicitly specified in the CREATE VIEW statement.


Action

Enter a column name for each column in the view in parentheses after the view name.