返回数说广场
0
表CUSTOMERS存在number类型的CUST_CREDT_LIMIT列。如下哪两个查询可以执行成功?BE
A
SELECT TO_CHAR(NVL(cust_credit_limit * .15,‘Not Available’)) FROM customers;
B
SELECT NVL2(cust_credit_limit,TO_CHAR(cust_credit_limit * .15),‘NOT Available’) FROM customers;
C
SELECT NVL2(cust_credit_limit * .15,‘Not AvailabIe’) FROM customers;
D
SELECT NVL(cust_credit_limit * .15, ‘Not Available’) FROM customers;
E
SELECT NVL(TO_CHAR(cust_credit_limit * .15),‘Not available’) from customers;
0
0 110
分享
评论
热门数说



