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




EnterpriseDB: Navicat
Oracle Tips by Burleson


Available at:

Navicat is the most feature rich of all the tools in this chapter but it does not have a free version.  You can download a fully functional trial version from the site above.

It has a very familiar interface and is very easy to use.  I like the fact that it has code completion and the query builder is very nice for new users.  Of all the products, it is the only I have found that has an integrated scheduler.

You will perform all of the familiar steps with this tool that you do with the others: add a server, browse databases in a navigator tree, etc.  The main screen is laid out very efficiently (Figure 5.66).

Figure 5.66: Navicat Main Window

I almost wish that at least one of the tools had chosen a different paradigm for navigating database objects.  The tree view is probably the most efficient and/or easy to learn but it would be nice to mix it up a bit.

Viewing data in Navicat follows the familiar Developer Studio and pgAdmin method of popping up a new window (Figure 5.67).  I prefer the SQL Manager method of having the data available with a tab click.

Figure 5.67: Navicat View Data

Creating and running queries takes a new turn in Navicat though.  The query builder (Figure 5.68) can make life much easier for those new to databases or new to an application.

Figure 5.68: Navicat Query Builder

The query text is populated as you select tables and columns.  Adding relations is as easy as drag and drop.  You can view the completed query in the Query Editor tab (Figure 5.69).

Figure 5.69: Navicat Query Editor

When you run the query (by clicking the Run button), a new tab is created with the results (Figure 5.70).

Figure 5.70: Navicat View Query Results

 The final feature in Navicat that I wanted to mention is the integrated scheduler (Figure 5.71).  While it may not be a needed feature for casual users, DBAs and administrators frequently need to schedule small jobs and having it integrated in the IDE is a nice bonus.

Figure 5.71: Navicat Scheduler


This chapter covered development in EnterpriseDB Advanced Server with Developer Studio in full detail.  In this chapter, I have shown how to configure connections to EnterpriseDB, PostgreSQL and Oracle and how to browse those databases.

Developer Studio will browse Oracle databases but only creates objects in EnterpriseDB and PostgreSQL.  In this chapter, I show how to use the wizards in Developer Studio to create databases, schemas, tablespaces, tables, views, sequences, synonyms, users and roles.  You should also be able to drop objects using Developer Studio.

Developer Studio provides many tools useful for developers and DBAs:

* PL/Debugger to debug procedural code

* Visual Explain Plan to see a graphic representation of query execution plans

* Backup and Restore to protect you data

* Online Migrations of Oracle objects and data to EnterpriseDB Advanced Server

* SQL and Procedural Code edit tools

As powerful as Developer Studio is, it may not provide all of the features you need to be most successful at your job.  The chapter ended with an overview of three third-party IDEs: the free pgAdmin III, the lite version of EMS SQL Manager and the commercial product Navicat.

The next two chapters, EnterpriseDB Management Server and EnterpriseDB Replication, will complete the coverage of the EnterpriseDB toolset. 


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