Databases Reference
In-Depth Information
Figure 2-11.
The SQL Workshop home page
Because there may be more than one schema assigned to the workspace, a schema-selection dialog at right
allows you to select and set the default schema for all the tools. You may change the schema you're working in within
each of the tools as well.
The main tools available as part of the SQL Workshop are displayed in the toolbar at the top of the page. Each of
the individual tools deserves its own introduction, so let's spend some time now looking at what they are and what
they can achieve. You'll use this area of APEX more heavily when you create the database objects for your application.
The Object Browser
If you've been working with databases for any length of time, you've probably used one of the more popular GUI
tools that allow you to browse and manage database objects in a schema. The APEX Object Browser is a very similar
tool presented through your web browser. Figure
2-12
shows the Object Browser being used to examine the table
EBA_DEMO_MD_DEPT
.
