Which action needs to be performed?

User Details form page is page 1 in your application. On this page the end user is required to
provide his Name and Address details- You need to create a validation that requires the end user
to enter a province if the country is not the United States (US).
Which action needs to be performed?

User Details form page is page 1 in your application. On this page the end user is required to
provide his Name and Address details- You need to create a validation that requires the end user
to enter a province if the country is not the United States (US).
Which action needs to be performed?

A.
Create a validation of type SQL and enter the following in the validation method;
SELECT 1 FROM CUSTOMERS
WHERE COUNTRY= �US’ AMD PROVINCE IS NULL

B.
Create a validation of type PL/SQL Function Returning Boolean and enter the following in the
validation method:
BEGIB
IF :Pi_COUNTRY = ‘US’ AMD : Pl_PROVINCE IS NULL THEN
RETURM FALSE;
ELSE
RETURN TRUE;
END IF;
END;

C.
Create a validation of type PL/SQL Function Returning Boolean and enter the following in the
validation method;
begin
IF :P1_COUNTRY != �US’ AND ; Pl_PROVINCE IS NULL THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
END;



Leave a Reply 0

Your email address will not be published. Required fields are marked *