Databases Reference
In-Depth Information
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.
■
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.
Note
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.
2.
Using the tabbed navigation bar across the top of the Home page, pull down the
SQL Workshop
submenu by clicking the arrow on the right side of the tab (see Figure
4-1
).
Figure 4-1.
Navigate to the Object Browser
