EnterpriseDB: Developer Studio Menu
Oracle Tips by
Developer Studio menu is fairly basic. The most common tasks are
duplicated on the toolbar just below the menu (Figure 5.4).
5.4: Developer Studio Menu and Toolbar
menu (Figure 5.5) allows you to add additional EnterpriseDB,
PostgreSQL or Oracle databases. This feature is covered below.
5.5: File Menu
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,
5.6: SQL Menu
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
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.
5.7: Tools Menu
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.
5.8: Developer Studio Preferences
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.
5.9: Help Menu
Toolbar, Figure 5.4, just below the menu, puts the more common
functionality in an easy to access place. The options from left to
* Add a
new server connection
an object – depends on the node high-lighted in the navigator
an object – will drop the high-lighted object
Debugger when a procedure is high-lighted
Global Breakpoint – for Debugging
Right-Click, Smart Menu
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.
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.
5.10: Table Smart Menu
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.
Add Server opens the Add Server dialog (Figure 5.11).
5.11: Add Server Dialog
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.
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.