Re: Multiple sort orders with one query

Użytkownik B Rabbit napisał:

> 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?
>

You might write output of query to a temporary table, and base your report on that table.

But first try to optimize your query.

-- 
Noel