Re: pl/sql conditional cursor?

From: Peter Kallweit <p_kallweit_at_arcor.de>
Date: Thu, 04 Jun 2009 11:05:56 +0200
Message-ID: <4a278e75$0$32677$9b4e6d93_at_newsspool2.arcor-online.net>



steph wrote:
> hi,
>
> Oracle 10g. In a procedure I have some code like
>
> declare
> cursor c1 is
> select x,y
> from tab1,tab2
> where <condition1>
> and <condition2>
> and <condition3>;
> begin
> for r1 in c1 loop
> <some code>
> end loop;
> end;
>
> Now I want to turn condition 3 on/off depending on one of the
> procedure's parameters - without having to define a second cursor
> (because this would mean duplicating some amount of code). So what I
> don't want to do is this:

Hi Stephan,

how about

   cursor c1 is
   select x,y

      from tab1,tab2
    where <condition1>

       and <condition2>
       and (<parametersaysoff> or <condition3>);

hth
Peter Received on Thu Jun 04 2009 - 04:05:56 CDT

Original text of this message