ocp 11g認(rèn)證題庫詳解：1Z0-051-077題，完整題庫請點擊這里聯(lián)系老師咨詢了解

77. In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the

CUST_FIRST_NAME 'ABIGAIL'.

Evaluate the following query:

SQL> SELECT INITCAP(cust_first_name ' '

UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))

FROM customers

WHERE cust_first_name = 'ABIGAIL';

What would be the outcome?

A. Abigail PA

B. Abigail Pa

C. Abigail IS

D. an error message

Answer: B

試題解析：

此為嵌套函數(shù)，由里到外可知：

LENGTH(cust_city)=LENGTH('Paris')=5

SUBSTR(cust_city,-5,2)=從右往左第5個，在順著輸出2個字符，即Pa

UPPER(Pa)=PA

INITCAP(cust_first_name ' ' UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))=INITCAP('ABIGAIL' '' 'PA')=Abigail Pa

即選B。