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