96.Examine the structure of the INVOICE table.

最新推荐文章于 2020-03-13 20:30:00 发布

今年我18

最新推荐文章于 2020-03-13 20:30:00 发布

阅读量1.4k

点赞数

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.csdn.net/dwj19830118/article/details/50803174

版权

96.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
解析：
nvl2是干啥的参考95题
类型参看下面的
The argument expr1 can have any data type. The arguments expr2 and expr3 can have any data types except LONG.
If the data types of expr2 and expr3 are different, then Oracle Database implicitly converts one to the other. If they cannot be converted implicitly, then the database r