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 A is wrong?
because the INIT cap function takes as parametre the whole expression including the ‘PA’