Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




Development Within EnterpriseDB Advanced Server
Oracle Tips by Burleson

EnterpriseDB Advanced Server is a robust database that supports a large set of programming languages.  EnterpriseDB also provides a robust development environment called Developer Studio.  We briefly covered some of the features of Developer Studio in Chapter 2.  In this chapter, I will walk through those features in detail.

In addition to developing for EnterpriseDB, Developer Studio allows you to develop applications for PostgreSQL databases and to browse Oracle databases.  This chapter will show you how to connect to those databases, navigate around them and even copy data and objects between them.

I will also show you how to use Developer Studio to write SQL and procedural code (for any of the supported languages).  The SQL Interactive window is the GUI interface to programming and the SQL Terminal is your character-based interface.

This chapter will also cover tuning your queries by using the Visual Explain tool.  This tool graphically displays your SQL execution path. 

An IDE is only as good as its debugger.  Developer Studio provides an excellent source level debugger to step through your programs.  With the PL Debugger, you can walk through SPL and PL/pgSQL at the source code level; you can view and change program variables.

Developer Studio is a very robust and complete solution for developing applications for EnterpriseDB.  However, it is not the only tool that you can use.  Because EnterpriseDB is based on PostgreSQL, there is a large supply of third party development tools.  This chapter will also cover three of the more feature rich tools: the free pgAdmin III GUI IDE and EMS PostgreSQL Manager Lite, and the commercial PremiumSoft Navicat for PostgreSQL GUI front end.

Developer Studio

Developer Studio (Figure 5.1) is an Open Source Java IDE to allow developers and DBAs to code for, and monitor, EnterpriseDB databases.  Developer Studio is a cross platform application that can also connect to PostgreSQL and Oracle databases.

Figure 5.1: EnterpriseDB Developer Studio Splash Screen

To run Developer Studio, click on the DevStudio icon (Figure 5.2) or select Developer Studio from the EnterpriseDB Advanced Server menu.

Figure 5.2: Developer Studio Icon

By Default, when Developer Studio starts, it should automatically connect to your local database and you should see a screen much like that in Figure 5-3.

Figure 5.3: Developer Studio


Navigation within Developer Studio is provided via four panes:

* Menu Pane – The menu pane provides the drop down menu and the toolbar. 

* Navigator Pane – The navigator pane provides an Explorer-like, tree-view of databases and database objects.  You drill down from the top level to lower levels by clicking the plus symbol (+).

* Details Pane – The details pane provides detailed information about the object selected in the navigator pane.  For example, when you select Schemas in the navigator pane, the details pane will contain a list of all schemas.  If you drill down and select a specific Schema, the details pane will contain information relating to the specific schema.

* SQL Pane – The SQL pane provides SQL scripts relating to the object selected in the navigation pane.  For example, when selecting Schemas in the navigator pane, the SQL pane is empty because there is no SQL associated with all schemas.  If you drill down and select a specific schema, you will see the SQL related to the specific schema.

You may also drill down to additional SQL information by selecting an object within the details pane. 


This is an excerpt from the book "EnterpriseDB: The Definitive Reference" by Rampant TechPress.


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter