In the CUSTOMERS table, the CUST_CITY column contains the value ‘Paris’ for the
CUST_FIRST_NAME ‘ABIGAIL’. Evaluate the following query: What would be the outcome?
A.
Abigail PA
B.
Abigail Pa
C.
Abigail IS
D.
an error message
What would be the outcome?
In the CUSTOMERS table, the CUST_CITY column contains the value ‘Paris’ for the
CUST_FIRST_NAME ‘ABIGAIL’. Evaluate the following query: What would be the outcome?
Why not A???
Because the starting index is negative means start from the end of the string
Isn’t a correct option? It should be? Plzz help
Just cause INITCAP
B is correct !
SELECT INITCAP(‘Abigail’||’ ‘||UPPER(SUBSTR(‘Paris’,-LENGTH(‘Paris’),2)))FROM DUAL;
Abigail Pa