Databases Reference
In-Depth Information
3.
Click the
Object Browser
option.
4.
In the Object Browser, click the
Create
button in the upper-right corner and select
Table
from the drop-down menu.
The Create Table Wizard opens. The first screen (Figure
4-2
) allows you to name the table and enter the details for
each of the table's columns. Using the two arrows in the Move column, you can move the columns into whatever order
you like. This affects the order in which they're defined and stored in the table. If you run out of empty rows to enter
columns into, you can click the Add Column button to add a new empty column definition row to the form.
Figure 4-2.
Defining the table and its columns
Enter the details for the
TICKETS
table as indicated in the ERD from the end of Chapter 3
and in Figure
4-2
. Then click
Next
.
5.
The next page (Figure
4-3
) lets you choose how you would like the primary key to be populated and which
column to use as the primary key. The four options for primary key are fairly self-explanatory, but the two in the
middle are probably the most common. You're starting from scratch and therefore don't have any existing sequences
defined in your database. By selecting “Populate from a new sequence,” you tell APEX to create a sequence for you
and create a database trigger on the table that will populate the selected primary-key column with the next value from
the sequence, unless the field already has a value. You're given the chance to name the sequence in this step as well.
In this instance, you'll use the default name given.
