 |
|
EnterpriseDB: Developer Studio Menu
Oracle Tips by
Burleson
|
Menu
The
Developer Studio menu is fairly basic. The most common tasks are
duplicated on the toolbar just below the menu (Figure 5.4).
Figure
5.4: Developer Studio Menu and Toolbar
File
The File
menu (Figure 5.5) allows you to add additional EnterpriseDB,
PostgreSQL or Oracle databases. This feature is covered below.
Figure
5.5: File Menu
SQL
The SQL
Menu, Figure 5.6, allows you to open the SQL Interactive, SQL Terminal
and Visual Explain windows. Each of those will be covered, in detail,
below.
Figure
5.6: SQL Menu
If you
are highlighting a table or view when you select this menu option, you
may also choose View Data. View Data will open a SQL Interactive
window and automatically run a query selecting all data from the
selected object.
Tools
The
Tools Menu, Figure 5.7, provides Backup and Restore functionality. If
you have a stored procedure high-lighted in the navigator, you can
also launch the PL Debugger.
Figure
5.7: Tools Menu
The
Tools menu also contains the Preferences option (Figure 5.8). The
Preferences dialog allows you to set your default transaction control
and to configure your SQL Terminal command line.
Figure
5.8: Developer Studio Preferences
Help
The Help
Menu, Figure 5.9, launches your default browser and navigates to the
Online Manual at EnterpriseDB.com. You can also view an About box
with copyright information.
Figure
5.9: Help Menu
Toolbar
The
Toolbar, Figure 5.4, just below the menu, puts the more common
functionality in an easy to access place. The options from left to
right are:
* Add a
new server connection
*
Refresh Node
* Create
an object – depends on the node high-lighted in the navigator
* Drop
an object – will drop the high-lighted object
* Launch
SQL Interactive
* Launch
SQL Terminal
* Launch
Visual Explain
* Debug
–
Launch
PL
Debugger when a procedure is high-lighted
* Set
Global Breakpoint – for Debugging
Right-Click, Smart Menu
All
objects within the navigator pane have an associated smart menu. To
see the smart menu, highlight an object in the navigator pane and
press the right mouse button. At a minimum, the object will have the
refresh command to refresh the node in the tree view.
Some
objects, such as tables, views and stored procedures have many items
(Figure 5.10) from which you may select. It is most often more
convenient to use the smart menus rather than the top menu pane.
Figure
5.10: Table Smart Menu
Connections
Developer Studio can be configured to connect to EnterpriseDB Advanced
Server, PostgreSQL and Oracle. The connection dialog is accessed from
the File menu, the toolbar or by right-clicking on the Servers node in
the navigator pane.
Choosing
Add Server opens the Add Server dialog (Figure 5.11).
Figure
5.11: Add Server Dialog
If you
choose New, you will be taken to an empty new Server dialog. Edit
opens the same dialog with the information of the selected connection
populated. Copy will create a copy of the selected connection and
Remove will permanently delete the connection.
This
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress. |
