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?

Use a WITH query.

Demo in Morgan's Library at www.psoug.org ... scroll down to WITH.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org