Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Altering the ORDER BY clause based on a parameter

Re: Altering the ORDER BY clause based on a parameter

From: jeremy <jeremy0505_at_gmail.com>
Date: Mon, 19 Nov 2007 08:42:14 -0000
Message-ID: <MPG.21ab5cc0c519b72698a4bf@news.individual.net>


In article <An00j.28383$mv3.7435_at_newsfe10.phx>, Ana C. Dent says...

>
> Dynamic SQL
>

Ok I know is possible with dynamic SQL, is there a way of achieving without using dynamic SQL?

If I understand correctly, dynamic sql is less efficient (has to be parsed every time?) so am looking for the most efficient solution.

-- 
jeremy
Received on Mon Nov 19 2007 - 02:42:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US