暂无图片
返回数说广场
张欣
暂无图片
2024-09-27
表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
分享

评论

热门数说