After posting Navicat administration tools for mysql database, here is another version of Navicat administrator and development tools, Navicat for Oracle which allow you to remote administrate oracle database or query SQL code from Mac or Windows system easily.
Navicat for oracle database server administration and development tool consider powerful tools because it contains a lot comprehensive database tools to create, organize, access and share oracle data securely.
On Oracle database management, Navicat Oracle offers specific administration features to perform and simplify day-to-day database admin routines such as create and maintain Oracle objects including Directory, Tablespace, Synonym, Stored Procedure, Package, Index, Materialized View, Trigger, Sequence, Type and so on. Plus more, features such as Data/Structure Synchronization, Import/Export, Backup database, Report, database task scheduling, code completion also included.
On development side, Navicat for Oracle offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL Console, TEXT, Hex and BLOB viewer/editor and more, to increase your Oracle productivity.
On connection options, Navicat for Oracle offers two connection modes to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic mode and alias entry from a tnsnames.ora file in TNS mode. Beside that, you can use SSH Tunnel connection on Navicat Oracle to connect your oracle database which enjoying a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.
Meanwhile, here is a Visual Tutorial that will guide you through the most commonly used features in Navicat on Oracle database management. To learn more about Navicat for Oracle, please visit at: NaviCat for Oracle.