them to Oracle by defining a few functions to replace
parts of the query.
Dave
-Original Message-
From: Harvinder Singh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 12:31 PM
To: Multiple recipients of list ORACLE-L
Subject: converting case in sqlserver to oracle
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
It's not pretty, but something like this should work:
select au.id,
decode(au.id_pi_instance,null,id_view, decode(pi_props.n_kind,15,
decode(child_kind.nm_productview,ed.nm_enum_data,au.id_pi_instance +
0x4000, au.id_pi_instance), au.id_pi_instance),
au.id_pi_instance),
au.instance, ...