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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).