Databases Reference
In-Depth Information
The first page of the Create Lookup Table Wizard (Figure
4-17
) gives you the option to show only
VARCHAR
column
types or all column types. It defaults to
VARCHAR
because that's most likely to be the candidate for lookup tables.
Looking at the columns presented in the wizard, you see that one of the
VARCHAR
columns is your
STATUS
column.
Figure 4-17.
Selecting the
STATUS
column as the source of your lookup table
4.
Select
STATUS
as the column from which you want to create the lookup table, and
click
Next
.
5.
On this screen you can name your lookup table and the sequence that is related to it. APEX
has chosen a reasonable name for the new table and sequence, so take the defaults and
click
Next
.
6.
The final screen of the wizard (Figure
4-18
) provides you with information about the
choices made and the action that is about to be performed. It's easy to miss the SQL syntax
link just below the wizard region. Click the
SQL
link to show the SQL.
Figure 4-18.
Clicking the SQL syntax link shows the SQL about to be executed