Question 61
Morgan has a report and form on the EMP table. He updated the form by adding a display-only item P5_Loc and change event dynamic action on PS_DEPTNO to populate the Item using Set Value with this SQL:
select loc from dept
where deptno = :P5_DEFTNO;
When Morgan runs the patje, he gets this error:
apex_error_code:
WWV_FLOW_DML. COLUMN_NOT_ FOUND
original massage: Column LOC not found in table EMP
What should Morgan do to prevent this error?
Question 62
You created an application where the home page looks like:
You now want to change the page to look like:
What do you need to do to change the appearance of the page?
Question 63
Susan created Page 10 as an interactive report, called Departments, on the DEPT table. She also created Page
11 as an interactive report on the EMP table, called Employees.
Susan would like to add a link in the Departments report (Page 10) that redirects to the Employees report (Page 11) and displays only employees for the selected department.
How would Susan set items in the link builder on Page 10 to correctly call the report on Page 11?
Question 64
John has a form page with an email item and a status item.
What must John do to ensure that the email Item is populated before users can enter any value into the status Item on the form page?