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

Email This Post Email This Post

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.

Popularity: 77% [?]

Related Post

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Close
E-mail It