Add a Column

Next, add a column to display the results of the employees' salary calculations.

To add a column:

1. Navigate to the Page Definition for page 3:

   1. On the SQL Commands page, click the Home breadcrumb link.

   2. On the Workspace home page, click Application Builder.

   3. Select the AnyCo Corp application.

   4. Click 3 - Employees.

      The Page Definition for page 3, Employees, appears.

2. Under Regions, click the Employees link (next to Report).

   
   Description of the illustration reg_emplrpt.gif
   
   

   The Region Definition appears.

3. Scroll down to Source, and replace the existing code with the following:

   SELECT "EMPLOYEE_ID", 
       "FIRST_NAME",
       "LAST_NAME",
       "HIRE_DATE",
       "SALARY",
       "COMMISSION_PCT",
       calc_remuneration(salary, commission_pct) REMUNERATION
   FROM "#OWNER#"."OEHR_EMPLOYEES"
   

4. Click Apply Changes.