Navicat Database tool for Oracle

From Oracle FAQ
Jump to: navigation, search

Navicat Oracle GUI is a tool for Oracle administration and development which lets you create, edit databases, import/ export data, build report and create/ run SQL queries and connect to remote Oracle in an easier way. It features an intuitive GUI and offers powerful visual tools such as Import/ Export Builder, Query Editor with syntax highlight capability, SQL Preview, Build in SQL*Plus, TEXT, Hex and BLOB viewer/editor, SSH Tunnel, Report Builder and more, to increase your productivity.

Also, Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks and a full featured graphical manager for setting the users and access privileges.

Navicat for Oracle can connect to any Oracle Database version 8i and later and runs on Windows and Mac OSX with remote connection capability. Navicat is also available for MySQL and PostgreSQL.


A partial list of the features:

Data Query and Manipulation:

  • Query Editor with syntax highlight & code completion
  • Visual Query Builder
  • Import/ Export Wizard
  • Data Transfer
  • Data/ Structure Synchronization

Database administration:

  • Management of Oracle objects and data
  • TEXT, Hex and BLOB viewer/editor
  • Print Database/ Table Structure
  • Character set and Unicode support
  • Dump object definition as sql file
  • Export Registry Record(.reg)
  • Foreign Key Data Selection
  • SQL Preview
  • Form View

Other useful features:

  • Visual User Manager
  • Tasks Scheduling
  • Build in SQL*Plus
  • e-mail notification
  • Virtual Grouping
  • Server Monitor
  • Profile System
  • Report Builder
  • SSH Tunnel
  • Docking


In addition to email support for customers, Navicat Oracle also hosts a Knowledgebase providing help to the customers.

External links[edit]