Re: DECODE and NVL

From: <fitzjarrell_at_cox.net>
Date: 29 May 2007 12:49:54 -0700
Message-ID: <1180468194.191214.200300@u30g2000hsc.googlegroups.com>

On May 29, 2:27 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> "maomao" <m..._at_mailinator.com> wrote in message
>
> news:135ov26mb4pav8f_at_corp.supernews.com...
>
> > 10gR2
>
> > I'm kind of self-doubting now, I'd like to run this by you gurus;
>
> > I see this in pl/sql : (written by God-knows-who)
>
> > DECODE(some-number-column, NULL, 0,some-number-column)
>
> > Is this in fact SAME as NVL(some-number-column, 0) ???
>
> > thanks
>
> Looks the same to me.
> --
> Terry Dykstra

Only spelled differently. :)

David Fitzjarrell Received on Tue May 29 2007 - 14:49:54 CDT