nvl [message #37904] |
Tue, 05 March 2002 19:57 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
.how does nvl work?
|
|
|
Re: nvl [message #37911 is a reply to message #37904] |
Wed, 06 March 2002 01:34 |
Manoj
Messages: 101 Registered: August 2000
|
Senior Member |
|
|
hi,
It simply Replace a null value to a provide value .
select nvl(r_no,'no roll') form try;
when it fetch data a find out null value of r_no column then it simply show y no roll.
it very usefull with numerical data ,because u cannot compair null with any char or num value.
|
|
|
Re: nvl [message #37923 is a reply to message #37904] |
Wed, 06 March 2002 10:42 |
sfhollands
Messages: 15 Registered: October 2001
|
Junior Member |
|
|
NVL function checks the value of a given variable and if the value is NULL then considers the value specified by the user
nvl(bonus,0)
if the bonus value is null then takes value of bonus to be 0
as any calculations with a null value returns null
|
|
|