Skip to content
Advertisement

“ORA-00998: must name this expression with a column alias” i am having this error can anyone tell me what’s the problem and its solution

this is my sample code;-

Advertisement

Answer

Imagine writing a query for your new view.

Your column names – are you asking for a column called SUM(purch_amt), or are you trying to do a sum on a column called purch_amt?

You need to provide a valid column name for the view, either implicitly or explicitly. Adding an alias allows the database to implicitly figure out what to name your column.

Like so.

enter image description here

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement