Databases Reference
In-Depth Information
Figure 2-13.
Specifying the list of columns to include in the report
4.
Use the default settings for the next four pages of the wizard. After that you will
see a page that allows you to select the columns available in the form. Select all
the columns.
Tip
At this point, you may run into the
Column Names must be valid Oracle Identifiers
error. This may
happen if you include certain fields from the Oracle database that are reserved keywords or contain invalid
characters. The Oracle database exercises a higher level of freedom with regards to field names compared to
APEX. You can view Oracle's rules for naming database objects at the following link:
5.
In the next page, you can decide if you want to let your users insert, update, or
delete records from the Customers table through the report. Leave all the
options as Yes (see Figure 2-14).
