Database Reference
In-Depth Information
Clicking the name of an object displays its properties along with links to drill into more
details.
Although the interface for the Object Browser is pretty intuitive, there are some in-
teresting things to note. In the upper-right corner is a drop-down list that allows you to
set the current schema. The list contains all schemas currently assigned to the work-
space. You can switch between them simply by choosing a new one from the list.
Also, to the right of the drop-down list is a set of quick link icons that takes you dir-
ectly to the other tools in the SQL Workshop.
The SQL Commands Interface
The SQL Commands interface allows you to interact with the underlying schema(s) us-
ing standard SQL commands or PL/SQL as you would in any other GUI tool or
SQL*Plus. The difference is that you can save the statements for use at a later time.
Figure 2-13
shows a simple SQL statement as executed in the SQL Commands inter-
face.
