首页 071 正文

The customers table has a GUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully?

2020.2.1 071 41

(客户表具有数据类型为NUMBER的GUST_CREDIT_LIMIT列。哪两个查询成功执行?)

A SELECT TO_CHAR (NVL(GUST_CREDIT_LIMIT *.15, ‘NOTAVAILABLE’)) FROM CUSTOMERS;

B SELECT NVL2 (GUST_CREDIT_LIMIT’.15, ‘NOTAVAILABLE’) FROM CUSTOMERS

C SELECT NVL (CUST_CREDIT_LIMIT *.15, ‘NOTAVAILABLE’) FROM CUSTOMERS

D SELECT NVL (TO_CHAR (CUST_CREDIT_LIMIT *.15 ), ‘NOT AVAILABLE’) FROM CUSTOMERS

E SELECT NVL2 (CUST_CREDIT_LIMIT, TO CHAR (CUST_CREDIT_LIMIT * .15),’NOT AVAILABLE’ ) FROM CUSTOMERS

答案:DE

相关推荐:

评论

昵称*

邮箱*

网址