SQL Workshop - Beginning Oracle Application Express 4.2 - page 50

CHAPTER 4

SQL Workshop

Now that you have a graphical representation of what your underlying tables should
look like, in the form of an entity-relationship diagram (ERD), it's time to dig in and
start creating the objects. As mentioned before, you could use your ERD tool to generate
the scripts, but to get used to using the SQL Workshop, you'll create these objects from
scratch.

Note For this and many of the following chapters, you need to download the code
that accompanies the topic. If you haven't already done so, download the code .zip file
from this topic's home page at www.apress.com . Then unzip it to a directory where
you can retrieve the files easily.

Creating Objects with the Object Browser

SQL Workshop's Object Browser is somewhat misnamed, because it not only allows
you to view database objects but also lets you create and edit them. For now, you'll skip
the USERS table; you come back to it later in the topic. Right now, you'll focus on the
TICKETS and TICKET_DETAILS tables. From this point forward, you'll follow step-
by-step instructions interspersed with figures and discussions about what you're trying
to achieve and why you're doing it the way you are. Let's get started:
1.

Log into your APEX workspace. You're presented with the workspace's
Home page, which, unless you've been doing other work in this workspace,
probably looks a little sparse.