Home » RDBMS Server » Server Administration » emergency: order a query result !!!!!
emergency: order a query result !!!!! [message #374651] Fri, 22 June 2001 16:13
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.
Previous Topic: emergency: order a query result !!!!!
Next Topic: question regarding group by .....
Goto Forum:
  


Current Time: Mon Dec 23 19:17:25 CST 2024