Skip to content

LNNVL function

select  * from dual
where lnnvl(age <= 9);

Classic

select  * from dual
where age > 9 or age is null;

Ref

https://www.techonthenet.com/oracle/functions/index.php