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?
Select INITCAP(‘ABIGIL’ ||”||UPPER (SUBSTR(‘Paris’,-LENGTH(‘Paris’),2)) )from dual
>> Abigilpa
Only A is in capital letter
B is not the correct answer in ‘P’ is in CAPS
B is the correct answer. Please check the following query:
Select Initcap(‘ABIGAIL’ || ‘ ‘ || Upper(Substr(‘Paris’, – Length(‘Paris’), 2))) From Dual; –> Abigail Pa
As there is a space between name & city, both the values will be converted into Initial Capital mode.
The parenthesis enclosed the expression,Initcap is applied to all the statement.
select upper( substr(‘Paris’ ,-length(‘Paris’) ,2 )) from dual
returns :PA … INITSTR function convert to pa
B is correct because initcap enclose all ..