Navicat for Oracle

What is Navicat for Oracle?

Navicat for Oracle Software improves the efficiency and productivity of Oracle administrators and developers with a streamlined desktop. In addition to Oracle's core role, Navicat for Oracle offers a rich set of features including a Data Modeling Tool, Data Synchronization/Structure, Import/Export, and Report to facilitate the data maintenance process.

With its well-structured user interface, you can easily and quickly create, organize, access, and share information securely and efficiently by optimizing your Oracle administration. Navicat for Oracle works with Oracle database servers of versions 8i or above and supports most of the features of the latest Oracle objects, including Directory, Table Space, Synonym, Materialized View, Trigger, Sequence, Type, and more.

Navicat Cloud

Navicat provides users with The Navicat Cloud. Sync your connection settings, templates, queries, and virtual groups to the cloud and get real-time access anytime, anywhere. With Navicat Cloud you can enjoy every minute of your day to maximize your productivity.

A shared workspace so that you and your team members can collaborate on a project in real time.

Navicat Cloud offers synchronization and sharing solutions that are flexible and secure. You can easily access connection settings, queries, and templates with multiple devices and share simply to support collaboration with your coworkers from anywhere, on any device. Work together with your colleagues through our integrated and secure cloud services.

Anytime, Anywhere

Sync your connection settings, queries, templates, and virtual group information across all your devices, including Windows, Mac, Linux, and iOS. Files stored in The Navicat Cloud will automatically appear on the Navicat desktop and mobile version so you can have real-time access anytime, anywhere.

And, The Navicat Cloud Portal provides the comprehensive tools you need to manage your files and projects such as file download and analysis of recent activities, you can simplify user management and monitor your cloud services through a single interface, improving operational efficiency and reducing management costs.

Keep your work safe

Navicat Cloud uses the Amazon Simple Storage Service (Amazon S3) for all online storage. The files are stored using 256-bit AES encryption and transferred through a secure SSL tunnel between Navicat and our cloud service.

Two-step verification is an additional security feature that provides an advanced authentication solution for your Navicat Cloud account. Even if all the crashes happen on your computer and mobile devices, once your files are synced to the cloud, all your files will be kept safe.

Collaboration:

Navicat Cloud makes collaboration simple. You can create projects to share connections, queries, and modules with members of your team. Your files will always be up to date, allowing everyone to work on the latest version of a file.

You can take control of your project – by adding members you choose, defining the role of each member, and gaining visibility through Activity Logging to align your team aiming for greater productivity. We will continue to work together as a team.

Navicat Cloud is available on all Navicat products and all platforms including Windows, Mac OS X, Linux and iOS (iPhone, iPad, and iPod).

Secure Connection:

Navicat allows you to establish secure SSH sessions through SSH Tunneling, ensuring strong authentication and secure encryption between two hosts. The authentication method can use a password or a public/private key pair.

Object Designer

Create, modify, and draw database objects using professional object designers, available for all database objects such as Tables, Views, Functions/Procedures, Indexes, Triggers, and Sequences. Without the need to write complex SQL to create and edit objects you will know exactly what you are working on.

Table Viewer

Grid/Form View

Add, modify, and delete records using Grid View. Browse Grid View with features similar to spreadsheets like sorting and hiding group data, or use our editing wizards such as memos, hexadecimal, images, and more. Manipulate records using Form View. Enjoy a clean view of name and value fields without the constant concern of misinterpretation of the data.

External Key Data Selection

Use external key relationships in your database to anchor referenced lookup tables and automatically create drop-down lists. Without the need to constantly turn to the master table you can optimize your workflow and productivity.

SQL Builder/Editor

SQL Constructor

Visual SQL Constructor lets you create and edit queries/views without having to worry about syntax and the correct use of commands. Just select the operation you want to perform on the tables and it will write the SQL statements for you.

Autocomplemento

Quickly build SQL statements in SQL Editor with our self-in-connection feature. If you want to select properties from database objects or SQL keywords all you need to do is choose from the drop-down list.

Database Designer

Reverse engineering

Create a database model from an existing database using Navicat Reverse Engineer. View and edit the structure of your database, or create a graphical model and manage a database that supports it.

Advanced Engineering and ScriptIng Generation

Database synchronization provides a complete picture of the differences between databases. Create the synchronization script required to update the target databases and make them identical to your model.

ExportSQL provides full control over the final SQL script, generating referential integrity rules, individual parts of your model, comments, character sets, and more: saving you hundreds of hours of work.

PL/SQL Code Debugger

PL/SQL code debugger offers features such as defining breakpoints, stumming through the program, viewing and modifying variable values, and examining the call stack. Debug PL/SQL code, such as procedures and functions, object methods, and triggers directly from the Navicat workspace.

Data Manipulation Tools

Export and Import Assistant

Import data into a table from various formats such as Access, Excel, XML, TXT, CSV, JSON, and more. Import ODBC data after you set up a data source connection. Simply choose the tables you want to import or specify a query using the Add Query button. Similarly, you can export data in various formats, such as Excel, TXT, CSV, DBF, XML.

Data Transfer

Transfer data between databases effortlessly. You can export data as a SQL file with designated SQL formatting and encoding. This feature dramatically simplifies the data migration process.

Data/Structure Synchronization

Transfer data from one bank to another with a detailed analytical process. Similarly, you can compare and modify the table structures. For both data synchronization and structures, the target database can be on the source server or on another server.

Backup/Restore

Back up the databases that are important to you regularly. Back up or restore all tables, records, views. Rest assured that data corruption will not undo all your work.

Schedule

Profiles from different databases can be created in a single volume job that you can schedule to run at a specific time. Volume jobs can be created for Report Printing, Database Backup, Queries, Data Transfer, Data Synchronization, Import, and Export. Navicat can automatically send notification emails to specific senders after a task is complete. Easily share data with automatic attachment to exported file emails and printed reports.

Report Builder/Viewer * Available only for Windows edition

Create different types of reports with our easy-to-use Report Builder GUI. Create reports for invoices, statistics, address labels, and more. Produce your reports like – text, PDF, Lotus, Excel, graphic, HTML and more.

Navicat Report Viewer allows you to browse reports designed in Report Builder. You can share reports with users who do not have Navicat but who have Navicat Report Viewer installed.

Useful Tools

ER Diagram

Diaframa ER provides a better understanding of your database schema by viewing the graphical structure and allowing you to see the relationships between tables in a database.

Color Connection/Virtual Grouping

The Color Connection feature lets you know which server you are connected to. A color track indicator shown in the toolbar in the subwindow identifies the connections and their database objects. The Virtual Grouping feature allows you to better organize connections and objects by categorizing objects into groups.

Tree/Object Filter

Use the Tree/Object Filter feature to narrow down the list of displayed database objects. Just type in the text field and only the objects that start with the specified string will be shown.

Favorites

Navicat makes it easy to return to a database object that you visit frequently. By adding paths to your favorites list, you can navigate to a particular database object with a single click.

System Requirements

Windows

Microsoft Windows XP SP3, Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2003, Server 2008, Server 2012

Mac
Mac OS X 10.7 or above

Intel CPU

Linux

Ubuntu 12.04, Ubuntu 14.04, CentOS 6.7, CentOS 7, Fedora 22, Fedora 23, Linux Mint 13, Linux Mint 17.3, openSUSE 13.2, openSUSE 42.1