Re: Updating LOV values programmatically

Hi

Could you use something like following:

select a from table where x = y
and :bindvariable = 'a'
union
select b,c from table where x <> z
and :bindvariable = 'bc'

If you use this in LOV you have to include INTO clause also.

Rauno

>For extra clarification, I want to be able to have two very distinct
>queries, not just changing values in the query based on bind variables.
>
>so,
>
>select a from table where x = y
>
>and
>
>select b,c from table where x <> z
>
>
>not
>
>select a from table where x = :bindvariable
>
Received on Fri Oct 22 1999 - 20:51:57 CEST