Pages

Saturday, May 22, 2010

Step 4 – Apex Developer Day - Modifying a Table

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.

clip_image002

2.

Enter the following values, and click Next >.

Add Column: PROJECT_DEADLINE
Type: DATE

clip_image004

3.

Click Finish.

clip_image006

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.

clip_image008

5.

Enter the following values, and click Next >.

Add Column: PROJECT_PRIORITY
Type: NUMBER
Precision: 1

clip_image010

6.

Click Finish.

clip_image012

7.

The PROJECT_PRIORITY column is added. Click the Data tab to view the data.

clip_image014

8.

You see all the projects that were referenced in the APEX_TASKS table. You can change data from here. Click the Edit icon (clip_image016 ) on the left of PROJECT_ID for Public Website.

clip_image018

9.

For Project Deadline, enter one year from today's date. Enter 1 for Priority. Then click Apply Changes.

clip_image020

10.

You see the data that you added.

clip_image022

No comments:

Post a Comment