Database Reference
In-Depth Information
8. For
Tab Options
(
Figure 6-4
), select
Use an existing tab set and re-
use an existing tab within that tab set
. When the page refreshes, set
Tab Set
to
TS1 (Home)
, set
Use Tab
to
T_HOME
, and then click
Next
.
Figure 6-4.
Specifying tab options
APEX 4 introduced the ability to use
ROWID
as a primary key. This comes in handy
when you're dealing with a table that has a multicolumn natural primary key, but the
table already has a single column primary key defined, so you'll use that:
9. Set
Primary Key Type
to
Select Primary Key Column(s)
, ensure
that
Primary Key
is set to
TICKET_ID
, and click
Next
.
The primary key of the table is based on a sequence within the database, and there is
already a trigger in place that fills the primary key with the next sequence value, if the
primary key for the incoming record is null:
10. Set
Source Type
to
Existing Trigger
, as shown in
Figure 6-5
,
and
click
Next
.