Re: something like an If statement

From: Alex Schatten <alex.schatten_at_gmx.de>
Date: Thu, 5 Feb 2004 22:00:50 +0100
Message-ID: <bvuau1$s5$03$1@news.t-online.com>

"Bricklen" <bricklen-rem_at_yahoo.comz> schrieb im Newsbeitrag news:eZxUb.11178$An3.1496_at_edtnps84...
...
> Would the CASE statement be of any use here?
> What version of Oracle btw?

Hello Bricklen

its version 9i

How would you do this with a CASE
As you see in my example there are more rows possible. Afaik i thougt i can retrieve only one record. example:
SELECT CASE
  WHEN (SELECT count(*) FROM Structure WHERE ID = 1000) > 0     THEN 'yes'
    ELSE 'no'
  END
AS Test
from dual

Where now the yes or no is returned must be the union selects from my example and this want work.

regards, Alex Received on Thu Feb 05 2004 - 15:00:50 CST