|
|
| Re: Can Formula Column used in Order By Clause [message #141419 is a reply to message #141410] |
Mon, 10 October 2005 03:05   |
m_ashtiani
Messages: 27
Registered: August 2005
Location: Reno
|
Junior Member |
|
|
one way to this is to wrap your select with another select
i.e.
select x.a, x.b, x.c, x.d, x.e
from (
select a, b, c, d, formula() as e
from ...
where ...
) x
order by x.e
another way is to create a "sever side" function or function inside a "server side" package, then you can use formula directly in your order by
|
|
|
|
| Re: Can Formula Column used in Order By Clause [message #141435 is a reply to message #141419] |
Mon, 10 October 2005 05:02 |
cheesecake
Messages: 2
Registered: October 2005
Location: KL
|
Junior Member |
|
|
Initially, I did tried the function. But its pretty slow and afraid that it might contribute to the performance.
Again, since its Order By clause, it should have been lil bit slower.
I'll try with the first option. Nevertheless, I look for other option if available.
Thanks. It helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
