ORA-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.
ORA-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.
ORA-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.
