[thelist] [sql] oracle's equiv of COALESCE(...)
.jeff
jeff at members.evolt.org
Tue Aug 14 14:45:13 CDT 2001
matt,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Warden, Matt
>
> subject says it all. i'm looking for oracle's equiv
> of COALESCE(), which (at least in sql server) selects
> the first non-null value in a list passed as arguments.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
i believe it's NVL()
good luck,
.jeff
More information about the thelist
mailing list