Home » SQL & PL/SQL » SQL & PL/SQL » column alias
column alias [message #314780] Thu, 17 April 2008 14:30 Go to next message
Messages: 9
Registered: April 2008
Junior Member

I also have another error.

  2  AS
  3     SELECT Number,
  4            NAME,
  5            address1,
  6            address2,
  7            address3,
  8            address4,
  9            address5,
 10            username,
 11            phone,
 12            extension,
 13            fax,
 14            code,
 15            poNumber,
 16            poLineItem,
 17            ReportNumber,
 18            cNumber,
 19            PNumber,
 20            SUBSTR(reasonReturn, 1, 2000),
 21            SUBSTR(reasonReturn, 2001, 2000),
 22            SUBSTR(reasonReturn, 4001, 1000),
 23            contact,
 24            nformance
 25       FROM vwQuestions ;
          SUBSTR(reasonReturn, 1, 2000),
ERROR at line 20:
ORA-00998: must name this expression with a column alias


Re: column alias [message #314790 is a reply to message #314780] Thu, 17 April 2008 15:31 Go to previous messageGo to next message
Messages: 1844
Registered: November 2006
Senior Member
Is not the error description self-explanatory? If you do not think so, check http://ora-00998.ora-code.com/
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.

Do you really want the column to have name "SUBSTR(reasonReturn, 1, 2000)".
Anyway, you shall specify the desired name as alias.
Re: column alias [message #314942 is a reply to message #314780] Fri, 18 April 2008 06:21 Go to previous message
Messages: 2
Registered: April 2008
Location: Hyderabad
Junior Member
If you are creating a view with expression in select statement, it must have alias. You need to give col. alias for expression in line no. 20,21 & 22.

Previous Topic: How to drop and recreate a schema?
Next Topic: Concatenation and Insertion
Goto Forum:

Current Time: Sun Jul 23 10:27:04 CDT 2017

Total time taken to generate the page: 0.05717 seconds