order by (asc and desc)

Hi All,

  Is there a way of choosing which ordering to use (ascend or descend) depending on a flag.

like:

 select a
   from abc
  order by a decode(flag, 1, asc, 2, des)

I can use dynimic query, but too much.
Any help would be appreciated.

you can email me at
ericluu_at_hotmail.com
Thanks Received on Thu Nov 04 1999 - 16:05:16 CST