一、原题
二、题目翻译
三、题目解析
四、测试
A选项测试如下:
SQL> SELECT NVL2(sysdate,'Pending','Incomplete')
2 FROM dual;
NVL2(SYSDATE,'PENDIN
--------------------
Pending
NVL及NVL2函数的详细用法,参考:
http://blog.csdn.net/holly2008/article/details/25251513
Examine the structure of the INVOICE table.
name Null Type
INV_NO NOT NULL NUMBER(3)
INV_DATE DATE
INV_AMT NUMBER(10,2)
Which two SQL statements would execute successfully? (Choose two.)
A. SELECT inv_no,NVL2(inv_date,'Pending','Incomplete')
FROM invoice;
B. SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available')
FROM invoice;
C. SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)
FROM invoice;
D. SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')
FROM invoice;
答案:AC
name Null Type
INV_NO NOT NULL NUMBER(3)
INV_DATE DATE
INV_AMT NUMBER(10,2)
Which two SQL statements would execute successfully? (Choose two.)
A. SELECT inv_no,NVL2(inv_date,'Pending','Incomplete')
FROM invoice;
B. SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available')
FROM invoice;
C. SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)
FROM invoice;
D. SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')
FROM invoice;
答案:AC
二、题目翻译
下面是INVOICE表的结构:
下面哪些语句能执行成功(选择2个)?
下面哪些语句能执行成功(选择2个)?
三、题目解析
A选项正确,第一个参数是date类型,可以隐式转换成字符类型。
B选项不正确,inv_amt是number类型,inv_date是日期类型,最后一个参数是字符类型,number类型不能隐式转成日期类型,所以隐式转换时出错。
C选项正确,第一个参数是date类型,第二个参数是number类型,第三个参数是date类型,都可以隐式转换成number类型。
D选项不正确,第一,二个参数是number类型,第三个是字符类型,隐式转换时报错。
B选项不正确,inv_amt是number类型,inv_date是日期类型,最后一个参数是字符类型,number类型不能隐式转成日期类型,所以隐式转换时出错。
C选项正确,第一个参数是date类型,第二个参数是number类型,第三个参数是date类型,都可以隐式转换成number类型。
D选项不正确,第一,二个参数是number类型,第三个是字符类型,隐式转换时报错。
四、测试
A选项测试如下:
SQL> SELECT NVL2(sysdate,'Pending','Incomplete')
2 FROM dual;
NVL2(SYSDATE,'PENDIN
--------------------
Pending
NVL及NVL2函数的详细用法,参考:
http://blog.csdn.net/holly2008/article/details/25251513