Oracle and SQL Server null judgment

Oracle , SQL Server null value ( Null ) Judgment

SQL Server ReplaceNull:Isnull (ARG, value) For example, select isnull (price, 0.0) from orders. If the price isNullReplace the value with 0.0.   AndNullComparison:Is notNull, IsNull For example, select * from orders where price isNull, Price is equalNull For example, select * from orders where price is notNull, Price is not equalNull   Oracle ReplaceNull:Nvl (ARG, value) For example, select nvl (price, 0.0) form orders AndNullComparison:Is notNull, IsNull For example, select * from orders where price isNull, Price is equalNull For example, select * from orders where price is notNull, Price is not equalNull