emergency: order a query result !!!!! [message #374650] |
Fri, 22 June 2001 16:09 |
Annie Xie
Messages: 2 Registered: June 2001
|
Junior Member |
|
|
I need to order a query result by the elements of an array. See, I query for account numbers and other related data such as account balance for an array of accounts, and the result have to be in the same order as the array. I used 'order y decode()', it worked for
a small array, but doesn't work for a large array (over
400 ). Can anybody give me any suggestions as how to overcome this? Any better alternative than 'order by decode()'? Your prompt response is really appreciated.
|
|
|