Multiple sort orders with one query
From: B Rabbit <bdlangton_at_gmail.com>
Date: 1 Jun 2005 12:03:52 -0700
Message-ID: <1117652632.619596.167200_at_g44g2000cwa.googlegroups.com>
[Quoted] [Quoted] I have a report in Oracle Reports 6.0 that does the same query 3 [Quoted] 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? Received on Wed Jun 01 2005 - 21:03:52 CEST
Date: 1 Jun 2005 12:03:52 -0700
Message-ID: <1117652632.619596.167200_at_g44g2000cwa.googlegroups.com>
[Quoted] [Quoted] I have a report in Oracle Reports 6.0 that does the same query 3 [Quoted] 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? Received on Wed Jun 01 2005 - 21:03:52 CEST