[thelist] can i merge columns in an Oracle query?

Judah McAuley judah at wiredotter.com
Mon Mar 15 13:01:52 CDT 2010


On Mon, Mar 15, 2010 at 6:11 AM, Luther, Ron <Ron.Luther at hp.com> wrote:
> Really?  That would be cool.  And it would certainly be more elegant than nested NVLs!  But I always thought COALESCE was the MSSQL command for doing this.  It didn't used to work in Oracle.  Hmmm.  I don't see it listed in my "Oracle - The Complete Reference" volume.

COALESCE is the standard SQL version. The MSSQL (T-SQL) version is
IsNull(column,default)

Judah


More information about the thelist mailing list