一、原题
二、题目翻译
三、题目解析
View the Exhibit and examine the description for the CUSTOMERS table.
You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where CUST_INCOME_LEVEL has NULL in the CUSTOMERS table.
Which SQL statement will accomplish the task?
A.
UPDATE customers
SET cust_credit_limit = NULL
WHERE CUST_INCOME_LEVEL = NULL;
B.
UPDATE customers
SET cust_credit_limit = NULL
WHERE cust_income_level IS NULL;
C.
UPDATE customers
SET cust_credit_limit = TO_NUMBER(NULL)
WHERE cust_income_level = TO_NUMBER(NULL);
D.
UPDATE customers
SET cust_credit_limit = TO_NUMBER(' ', 9999)
WHERE cust_income_level IS NULL;
答案:B
You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where CUST_INCOME_LEVEL has NULL in the CUSTOMERS table.
Which SQL statement will accomplish the task?
A.
UPDATE customers
SET cust_credit_limit = NULL
WHERE CUST_INCOME_LEVEL = NULL;
B.
UPDATE customers
SET cust_credit_limit = NULL
WHERE cust_income_level IS NULL;
C.
UPDATE customers
SET cust_credit_limit = TO_NUMBER(NULL)
WHERE cust_income_level = TO_NUMBER(NULL);
D.
UPDATE customers
SET cust_credit_limit = TO_NUMBER(' ', 9999)
WHERE cust_income_level IS NULL;
答案:B
二、题目翻译
查看CUSTOMERS表的结构:
要更新CUSTOMERS表中所有customers的CUST_CREDIT_LIMIT值,当CUST_INCOME_LEVEL为NULL时更新CUST_CREDIT_LIMIT为空。
哪个SQL语句能完成此上面的要求?
要更新CUSTOMERS表中所有customers的CUST_CREDIT_LIMIT值,当CUST_INCOME_LEVEL为NULL时更新CUST_CREDIT_LIMIT为空。
哪个SQL语句能完成此上面的要求?
三、题目解析
在oracle中 ,判断列值是否为null,要用 列名 is null来判断,而设置值的时候,用等号(=)。