Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with Computed Column

Re: Problem with Computed Column

From: TheanKeong <theankeong_at_gmail.com>
Date: 28 Feb 2005 01:00:44 -0800
Message-ID: <1109581244.526562.20370@g14g2000cwa.googlegroups.com>


Hi again,
While searching for the solution i bumped thru this statement in one of Oracle related website

alias - provides a different name for the column expression and causes the alias to be used in the column heading. The AS keyword is optional. The alias effectively renames the select list item for the duration of the query. The alias can be used in the ORDER BY clause, but not other clauses in the query

could it be the source of my problem ? Received on Mon Feb 28 2005 - 03:00:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US