Navicat for Oracle 10.1.3

The No.1 Oracle Database Management GUI

Navicat for Oracle is a powerful database administration and development tool for Oracle. It works with any Oracle Database Server from version 8i or above and supports most of the latest Oracle objects. It also contains many advanced features like Data Modeling Tool, Import and Export, Debugger, Visual Query Builder, Data Transfer, Data and Structure Synchronization and Batch Job Scheduling.

Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server.

Powerful Visual Database Designer
Data Modeling Tool allows you to create graphical representations of a relational database. The Reverse Engineer feature enables you to create a database model from an existing database and graphically visualize and edit the structure of the database. Or, you can graphically create a model, and generate a database that supports the model.

In addition to creating model from database, Navicat Data Modeling also allows you to compare and synchronize between Models and Databases and generate SQL/ DDL scripts.

Advanced Oracle Management Tools PL/SQL Debugger offers all features you could wish for such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack. You can debug PL/SQL code such as procedures and functions, object methods, and triggers directly from the Navicat environment.

Excellent visual and text tools for query building
Visual Builder allows you to build complicated queries without any knowledge of SQL syntax. You can also experience a quick way in constructing SQL statements in SQL Editor with the code/word completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.

Impressive data export and import capabilities
Navicat for Oracle provides a robust set of features to insert new data into your database or extract data from it using a variety of formats to suit your purposes. You can import data into your databases from up to 5 most popular formats including XLS, XML, CSV, TXT and DBF to create new tables or update existing tables in your database. It also gives you complete control over the source data selected for export, allowing you to fine tune the content of the output with special refinement options for each format.

Powerful data manipulation tools
Advanced data transferring feature brings you a new level of reliability in transferring data between databases. Moreover, Naivcat synchronization tools provide the ability for data in different databases to be kept up-to-date so that each repository contains the same information.

Other useful features:

ER Diagram View

Backing up and restoring database

Setting schedules

Privilege manager

Form view

Text/Hex/Image viewer and editor

SQL Beautifier/Minifier

Connection coloring

Virtual grouping

Database Wide Search

Object Filter