[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