OCP-1Z0-051 第97题 NULLIF，NVL函数用法

最新推荐文章于 2023-06-30 14:34:57 发布

hello_holly

最新推荐文章于 2023-06-30 14:34:57 发布

阅读量4.6k

点赞数

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 NVL2 NULLIF 11g

本文链接：https://blog.csdn.net/holly2008/article/details/25294717

版权

该博客讨论了Oracle数据库中的NULLIF和NVL2函数，通过一道OCP-1Z0-051考试题目进行示例说明。内容涉及当AMT_SPENT等于CREDIT_LIMIT或为NULL时，如何使用这些函数来确定'1000'奖金的显示情况。解析解释了正确答案为何是C。

摘要由CSDN通过智能技术生成

一、原题

View the Exhibit and evaluate the structure and data in the CUST_STATUS table.

You issue the following SQL statement:
SQL> SELECT custno, NVL2(NULLIF(amt_spent,credit_limit), 0, 1000) "BONUS"
FROM cust_status;
Which statement is true regarding the execution of the above query?
A. It produces an error because the AMT_SPENT column contains a null value.
B. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
C. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null .