Now that you have the two main tables, enhance the APEX_PROJECT_LOOKUP table by adding some additional columns.
To do this, perform the following steps:
1. | Make sure the APEX_PROJECT_LOOKUP table is selected. You are going to add a column to the table. Click Add Column. |
2. | Enter the following values, and click Next >. Add Column: PROJECT_DEADLINE Type: DATE |
3. | Click Finish. |
4. | You see the modified table definition with the new PROJECT_DEADLINE column added. You want to create one more column for PROJECT_PRIORITY. Click Add Column. |
5. | Enter the following values, and click Next >. Add Column: PROJECT_PRIORITY Type: NUMBER Precision: 1 |
6. | Click Finish. |
7. | The PROJECT_PRIORITY column is added. Click the Data tab to view the data. |
8. | You see all the projects that were referenced in the APEX_TASKS table. You can change data from here. Click the Edit icon ( ) on the left of PROJECT_ID for Public Website. |
9. | For Project Deadline, enter one year from today's date. Enter 1 for Priority. Then click Apply Changes. |
10. | You see the data that you added. |
No comments:
Post a Comment