一、原题
http://blog.csdn.net/holly2008/article/details/25251513
The PRODUCTS table has the following structure:
name Null Type
PROD_ID NOT NULL NUMBER(4)
PROD_NAME VARCHAR2(25)
PROD_EXPIRY_DATE DATE
Evaluate the following two SQL statements:
SQL>SELECT prod_id, NVL2(prod_expiry_date, prod_expiry_date + 15,'')
FROM products;
SQL>SELECT prod_id, NVL(prod_expiry_date, prod_expiry_date + 15)
FROM products;
Which statement is true regarding the outcome?
A. Both the statements execute and give different results.
B. Both the statements execute and give the same result.
C. Only the first SQL statement executes successfully.
D. Only the second SQL statement executes successfully.
答案:A
二、题目翻译name Null Type
PROD_ID NOT NULL NUMBER(4)
PROD_NAME VARCHAR2(25)
PROD_EXPIRY_DATE DATE
Evaluate the following two SQL statements:
SQL>SELECT prod_id, NVL2(prod_expiry_date, prod_expiry_date + 15,'')
FROM products;
SQL>SELECT prod_id, NVL(prod_expiry_date, prod_expiry_date + 15)
FROM products;
Which statement is true regarding the outcome?
A. Both the statements execute and give different results.
B. Both the statements execute and give the same result.
C. Only the first SQL statement executes successfully.
D. Only the second SQL statement executes successfully.
答案:A
下面是PRODUCTS表的结构:
看下面两个SQL语句
关于结果,下面哪个描述语句是正确的?
A.两个都执行成功,但给出不同的结果。
B.两个都执行成功,并给出相同的结果。
C.只有第一个执行成功。
D.只有第二个执行成功。
三、题目解析看下面两个SQL语句
关于结果,下面哪个描述语句是正确的?
A.两个都执行成功,但给出不同的结果。
B.两个都执行成功,并给出相同的结果。
C.只有第一个执行成功。
D.只有第二个执行成功。
第一条语句当prod_expiry_date为null时输出第二个参数’’也是空,不为空时输出和一个prod_expiry_date + 15,
而第二条语句当prod_expiry_date为null时输出第二个参数,不为空时输出prod_expiry_date。
NVL及NVL2函数的详细用法,参考:而第二条语句当prod_expiry_date为null时输出第二个参数,不为空时输出prod_expiry_date。
http://blog.csdn.net/holly2008/article/details/25251513