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
Explanation:
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?
I think it’s A. Since Upper returns the whole string in uppercase, it should be “Abigail PA”.
I may be wrong, so if you have a different opinion, please explain.
B is the correct. The outer function is INITCAP, then the UPPER inner function will be replaced by it. Then the result will be “Abigail Pa” and not “Abigail PA”.
al tener -LENGTH hace comenzar de derecha a izquierda 5 espacios después el substr pide avanzar 2 espacios y por útlimo el INITCAP hace colocar solo “P” mayuscula y “a” minuscula
Thank you, Giovanni. You are right.