Re: Conditional Union ?

On Jun 20, 6:32 am, General Fear <richma..._at_earthlink.net> wrote:
> I am using 10g.
>
> Below is a crude example of what I am trying to do
>
> Procedure
> ( pi_input as interger
> )
>
> is
>
> Cursor A
>    is
> Select 'A' as Letter from Dual;
>
> Cursor B
>   is
> Select 'A' as Letter from Dual;
>    Union
> Select 'B' as Letter from Dual;
>
> If pi_input = 1 then
>   Open A
> Else
>   Open B
> End If
>
> Notice that Select 'A' as Letter from Dual  is in two cursors. If I
> have to make a change to Cursor A, I also have to do it again in
> cursor B because "Select 'A' as Letter from Dual' is in two cursors.
>
> Is it possible to eliminate repeat code in the above example? What do
> I need to do.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/sqloperations.htm#sthref1392

robert Received on Fri Jun 20 2008 - 03:31:53 CDT