Re: Similar to alias, but to be reusable in all clauses of SQL: SELECT

qazmlp1209_at_rediffmail.com wrote:
> I have to use only a converted form of a column value (E.g.
> SUBSTR(TO_CHAR(my_function(Column-1)),1,17))) in all the clauses of my
> SQL statement i.e. where, having, group by, order by clauses.
> The statement looks ugly if I put the samething in al the places. How
> can I make it to mention in only one place, so that I can reuse it in
> other parts of the SQL statement. I suppose I cannot use the column
> alias as it can be reused only at the Order by clause.
>
> A quick look at the PL/SQL tutorial did not fetch me anything related
> to it. Can anybody help here?
>

Create a view then query from the view.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown