Databases Reference
In-Depth Information
name to better reflect the feature. We thought we updated the wording everywhere— I guess we missed
the APEX view!
User Interface Defaults
Another handy and underutilized utility for reports is User Interface Defaults. Oracle Application
Express 4.0 introduced the Attribute Dictionary so you can now define standards based on just column
name rather than for each column within each table. This allows you to set a standard heading for
CREATED BY
. If you use UI Defaults during creation, that value will be picked up by the wizard but if not,
or if you define it after creation, you can use the Attribute Dictionary page available from the Page
Definition under Utilities (see Figure 13-37).
Figure 13-37
. Attribute Dictionary from within the Application Builder
For reports, this checks your column aliases against the Attribute Dictionary and then reports
attribute-by-attribute. You can then identify the attributes that you wish to “pull” into your report. You
can also “push” values into the Attribute Dictionary to use as your standards and then use those to
compare against other reports (see Figure 13-38). If consistency is your thing, this feature is for you!
