LNNVL function Options

[thiyagusham]

Hi to all ;
please review following table and clear my question ..


SQL> select * from tes1;

NAME SUB_MARK PRAC_MARK
---------- ---------- ----------
sam 120 70
sona 70 90
rose 90 90
sony 90
maya

SQL> select * from tes1
2 where lnnvl(sub_mark > prac_mark);

NAME SUB_MARK PRAC_MARK
---------- ---------- ----------
sam 120 70
sona 70 90
rose 90 90
sony 90
maya


As per lnnvl function it should display except first record (if condition evaluates true ,
function should return false value, )i.e. first record is true so should not disclose. Am I right ????. Please clarify …..

[burleson]

>> if condition evaluates true , function should return false value

Yes, that first row evaluates to "true" and gence, it should be false and NOT appear in your output:

http://www.dba-oracle.com/t_lnnvl.htm

I reproduced your condition and got different results:

CODE

create table tes1
(
myname varchar2(10),
sub_mark number,
prac_mark number);

insert into tes1 values ('sam', 120, 70);
insert into tes1 values ('sona', 70, 90);

select *
from tes1
where
   lnnvl(sub_mark > prac_mark);

For me, the first rows DOES NOT appear.

[thiyagusham]

thanks for reply