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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL in Stored Procedure

Re: Dynamic SQL in Stored Procedure

From: michael ringbo <mri_at_dde.dk>
Date: 1998/01/30
Message-ID: <34D1A028.87E90DF@dde.dk>#1/1

Hi Mark

Don't know if this works for you, but how about trying: order by decode(var1,'A',colA,colB)

Michael Ringbo
mri_at_dde.dk

Mark Aurit wrote:

> Im using the Oracle Web Server, and I want to give the customer the
> ability choose a sort; in other words, affect the ORDER BY. Their
> request will be passed to a stored procedure, and Im wondering how
> (and if) I can change the SQL dynamically. I could do something like
> IF var1 = 'A' THEN
> .. do some cursor stuff and issue a SELECT..
> ORDER BY colA
> ELSE
> ORDER BY colB
> END IF;
> But I hate the idea of all that code Ill have to duplicate. Can I say
> something like:
> IF var1 = 'A' then
> var2 := 'emp_id';
> else
> var2 := 'city';
> end if;
> Followed by:
> .. cursor stuff and a SELECT ...
> ORDER BY var2
>
> Or some such construct?
>
> Any ideas greatly appreciated.
> Mark_Aurit @ mail.northgrum.com
Received on Fri Jan 30 1998 - 00:00:00 CST

Original text of this message

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