Re: ISNULL() function for Oracle???
From: Kasten10 <kasten10_at_aol.com>
Date: 1995/09/27
Message-ID: <44c3hg$bcb_at_newsbf02.news.aol.com>#1/1
Date: 1995/09/27
Message-ID: <44c3hg$bcb_at_newsbf02.news.aol.com>#1/1
In article <44aeae$st7_at_ixnews4.ix.netcom.com>, Steve Perry <dpsmp_at_ix.netcom.com> writes:
>In MS SQL Server, we use the function isnull(col1, "empty") in our select
>statements. Ex. select isnull(col1, "empty") from tbl1. This will replace
>all null rows returned with 'empty'. Is there a similar function in
>Oracle??? I've been looking, but I didn't see one.
>
>
>
You want to look at nvl() and possibly even decode()
Chris Received on Wed Sep 27 1995 - 00:00:00 CET