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;