converting case in sqlserver to oracle

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Tue, 04 Sep 2001 09:46:00 -0700
Message-ID: <F001.00381FF3.20010904093055@fatcity.com>

Hi,

I have a procedure in sql server containg following case statement...(part of select clause)
how to convert this statement is oracle format: select au.id,
viewID = case when au.id_pi_instance is NULL then id_view else

        (select viewID = case when pi_props.n_kind = 15 AND child_kind.nm_productview = ed.nm_enum_data then

        -(au.id_pi_instance + 0x40000000)
        else
        -au.id_pi_instance 
        end)
        end,au.instance,............

Thanks
-Harvinder
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harvinder Singh
  INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 04 2001 - 11:46:00 CDT