DECODE and NVL

#1

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

#2

"maomao" <mm (AT) mailinator (DOT) com> wrote

Quote:

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

#3

On May 29, 2:27 pm, "Terry Dykstra" <tddyks... (AT) forestoil (DOT) ca> wrote:

Quote:

"maomao" <m... (AT) mailinator (DOT) com> wrote in message

news:135ov26mb4pav8f (AT) corp (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DECODE and NVL

comp.databases.oracle.server comp.databases.oracle.server

DECODE and NVL - 05-29-2007 , 02:17 PM

Re: DECODE and NVL - 05-29-2007 , 02:27 PM

Re: DECODE and NVL - 05-29-2007 , 02:49 PM