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


