（77）In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'ABIGAIL'.

Evaluate the following query:

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

答案：（B）

解析：

position为负数,则从后向前查，然后再向后取指定个数的字符。

ITPub博客

OCP 1Z0-051-77