Additional Connection Options

Native Connection Options
Navicat for Oracle offers one connection mode to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic mode.

Advanced Connection Options
You can set the role for user to connect with Default, SYSOPER or SYSDBA system privilege. Besides, you can pass control of user authentication to the operating system by means of OS authentication option.

Support of SSH Tunnel
Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.

Comprehensive Management of Oracle objects

Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, triggers and privileges
With Table Designer - the basic Navicat for Oracle tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, triggers, privileges and much more.

Support of tablespace, package, sequence, synonym, trigger, type and more
Navicat allows you to create, edit and drop directories, tablespaces, public database links, public synonyms, database links, indexes, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, xml schemas, recycle bin and more.

Dump object definition as sql file
Backup object definition and data with ease by dumping as sql file.

Print Database / Table Structure
Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.

Export data and create records as INSERT statements in sql file
During Data Transfer, you can choose to export data as sql file with record options like complete insert statements etc.

Data and Structure Synchronization
You can transfer data from one Oracle schema to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target schema can be on the same server as the source or on another server.

Send notification e-mail and attachment for schedule task
Generate notification e-mails with attach exported files to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.

Well-Designed Visual Builder / Editor

Visual Query / View Builder
Visual Query / View Builder - which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.

Support of Parameter Query
Set query parameters to add variable values to a query each time you run it.

Code-Completion for Query, View, Function and oracle objects
Experience a quick way in constructing SQL statements in SQL Editor with the Code-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.

Server Monitor
Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status Tab to show and/or modify the properties of Oracle servers.

Text / Blob View
Navicat provides Text / Blob Viewer and Editor to view and edit TEXT / BLOB fields content. The editor allows you to view, update, insert or delete data in a table.