Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Altering the ORDER BY clause based on a parameter
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.
-- jeremyReceived on Mon Nov 19 2007 - 02:42:14 CST
![]() |
![]() |