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?
Received on Wed Jan 17 2007 - 08:30:08 CST
