Re: Multiple sort orders with one query

B Rabbit wrote:
> I have a report in Oracle Reports 6.0 that does the same query 3
> different times, each with a different sort order. However, sometimes
> the query takes a long time and running the query 3 times is
> unacceptable. My question is, is there a way to just run the query one
> time, then somehow change the sort order dynamically so that I can
> output the query's results in the 3 different sort orders?

Not having any idea the database version: You didn't provide it. Not having any idea the amount of data: You didn't provide it. Not having any idea the DML statement: You didn't provide it. Not having the Explain Plans: You didn't provide them. Not having the nature of the sort order differences: You didn't provide it.

What kind of help do you expect?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)