Choose one of two values

From: Sashi <smalladi_at_gmail.com>
Date: Mon, 28 Sep 2009 07:40:31 -0700 (PDT)
Message-ID: <5b73087b-2fe5-4bda-a646-00b6548651cf_at_f33g2000vbm.googlegroups.com>

Hi all,

I'm running a simple select stmt thus:

select A.value, b.value
from A, B
where ...

However, either A.value or B.value is null and I need to select the non null value.
Is there a way of specifying within pl/sql this construct?

Pseudocode:

Select ( if (A.value) is null and (B.value) is not null then B.value

            else
            if (B.value) is null and (A.value) is not null then
A.value
            else
            if (B.value) is not null and (A.value) is not null then

A.value)
From A, B
where ...

In the third case above, either is ok so I arbitrarily cose A.value.

Hope this is clean enough.

Thanks in advance,
Sashi Received on Mon Sep 28 2009 - 09:40:31 CDT