OCP-1Z0-051-2015-53题

最新推荐文章于 2020-09-15 10:03:02 发布

原创最新推荐文章于 2020-09-15 10:03:02 发布 · 424 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

当前文章被以下社区和专栏收录：

本文详细介绍了SQL中NVL和NVL2函数的使用方式及区别，通过实例展示了如何根据条件返回不同结果。

QUESTION NO: 53

The PRODUCTS table has the following structure:

nvl如果不为空即是自己，nvl2如果prod_expiry_date 不为空即是prod_expiry_date +15

nvl如果prod_expiry_date 为空即是prod_expiry_date+15，nvl2如果prod_expiry_date 为空即是‘ ’

Which statement is true regarding the outcome?
A. Both the statements execute and give the same result
B. Both the statements execute and give different results
C. Only the second SQL statement executes successfully
D. Only the first SQL statement executes successfully
Answer: B
Explanation:
Using the NVL2 Function
The NVL2 function examines the first expression. If the first expression is not null, the NVL2
function returns the second expression. If the first expression is null, the third expression is returned.
Syntax
NVL2(expr1, expr2, expr3)
In the syntax:
expr1 is the source value or expression that may contain a null
expr2 is the value that is returned if expr1 is not null
expr3 is the value that is returned if expr1 is null