Shulou(Shulou.com)05/31 Report--

This article mainly introduces what is the use of the nvl function in Orcale and the isnull function of SQL Server. The introduction in this article is very detailed and has certain reference value. Interested friends must read it!

Nvl function of Orcal

NVL (Expr1,Expr2) returns the value of Expr2 if Expr1 is NULL, otherwise the value of Expr1, and the value of NULL if both Expr1,Expr2 are NULL

NVL2 (Expr1,Expr2,Expr3) returns the value of Expr2 if Expr1 is NULL, otherwise the value of Expr3

NULLIF (Expr1,Expr2) returns NULL if the values of Expr1 and Expr2 are equal, otherwise returns the value of Expr1

Coalesce (expr1, expr2, expr3... .. Exprn) indicates that placeholders can be specified for multiple expressions. All expressions must be of the same type or can be implicitly converted to the same type. Returns the first value of NULL

Return value type

Character type, date type, date-time type, numerical type, monetary type, logical type or null value

Isnull function of sql server

ISNULL (check_expression, replacement_value)

Parameters.

Check_expression is the expression that will be checked for NULL. Check_expression can be of any type.

The expression that replacement_value will return if check_expression is NULL. Replacement_value must have the same type as check_expresssion

These are all the contents of the article "what is the use of the nvl function in Orcale and the isnull function of SQL Server". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.