[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