Re: nvl

[Lakshmana Prasad <gantalp@YAHOO.COM>]

U can not compare the null value with null.
Null != Null  and
Null != ' '

Lakshman


--- the dragon <ceprn@HOTMAIL.COM> wrote:
> Soliman.
>
> nvl means null value.  This command will substitute
> a value for a column if
> it is null.  In your example, if the hdr_jon column
> returns a NULL value
> from the select, it will replace that null with a
> space.
>
> clark 'the dragon' willis
> dragon enterprises, consulting services
>
>
> ----Original Message Follows----
>
> Hello all,
> What nvl(hdr_jon, ' ') mean or nvl mean.
> Any help will be greatly appreciated.
> Heba
>
>
_________________________________________________________________
> Get your FREE download of MSN Explorer at
http://explorer.msn.com


=====
This Message from gantalp(Chinni).
All The best.

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text