substituting nvl2() with case - 09-18-2007 , 07:01 PM
I'm looking for an NVL2() substitute. Someone has suggested using case,
but I've always seen case in scripts, not in a single statement. For
example, NVL2() can be used in a single SQL statement like:
SELECT g3e_fid, hs_prefix, hs_number, hs_suffix,
hs_prefix || '-' || hs_number || hs_suffix,
hs_number || hs_suffix
Anyone have an example of using case in a single statement?