 |
| ||||
Navicat Essentials for Oracle is a professional database administration tool designed to simplify database management. It is built with an intuitive GUI which lets you create, organize, access and share information in a secure and easy way.
Navicat Essentials for Oracle works with any Oracle Database Server from version 8i or above, and supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc. It also comes with the import/export tools that assist you import/export txt and xml files to/from your Oracle databases.
Here are some key features of "Navicat Essentials for Oracle":
Oracle Objects Management:
· Support Oracle Servers 8.1 or above
· Create/drop schemas
· Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions
· Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers
· Managing directories, tablespaces, public database links and public synonyms
· Managing database links, indexes, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.
· Support of physical attributes
· Support of character set and unicode
Connection Management and Navigation:
· Multiple local/remote Oracle server connections
· Support of Basic Connection
· Support of TNS Connection
· Connection to Oracle Server through SSH
· Keep connection alive
· Export/Import connections settings
Feature Rich Oracle PL/SQL Code Debugger:
· Support on showing interactive and real-time debugging information
· Ability to set simple and complex breakpoints
· Stepping through a function, i.e. Step Into, Step Over and Step Out
· Inspecting variables and expressions
· Stack traces
Data Viewer and Editor:
· Grid view
· Form view
· TEXT, Hex and BLOB/BFile viewer/editor
· Copying and pasting selected records
· Customize display formats
· Incremental search, sorting and formatting table grid
· Ability to show/hide table ROWID
· Support of foreign key data selection: locate the available values from the reference table
· Filtering Records
· Ability to set number of records showing on each page
SQL Processing:
· Visual query/view builder to facilitate the process of building complicated queries
· Ability to create parameter queries
· Code completion for SQL editors
· Code outline
· SQL Code Beautifier/Minifier
· Multiple SQL editors with syntax highlighted feature
· Support code folding, highlighted matches words and brackets
· Copy SQL with quote
· Word Wrap
· Zoom In/Out for SQL editors
· Enhanced find and replace options in SQL editors
· Ability to preview SQL before execution
· Support to return multi-resultsets
· SQL*Plus
Data Modeling Tools:
· Reverse engineering
· Support of several diagram notations like Crow's Foot, IDEF1x and UML
· Ability to create/edit/drop database objects, visually set relationships between them
· Support of auto layout
· Support numerous visual customization options like adding vertices, layers, images and notes/labels
· Zoom In/Out for ER diagram
· Comparing and synchronizing database/model
· Generating complex SQL/DDL
· Multi-page print preview
· Ability to print the database diagram to PDF file
· Ability to save the database diagram as a graphic file, i.e. PNG, SVG
Diversified Import and Export Competence:
· Importing data from ODBC: MSSQL etc
· Importing data from MS Excel
· Importing data from MS Access
· Importing data from plain text file formats : TXT, CSV, XML etc
· Importing data from other file formats : DBF etc
· Exporting data to MS Excel
· Exporting data to MS Access
· Exporting data to HTML
· Exporting data to plain text file formats : TXT, CSV, XML etc
· Exporting data to most popular formats: DBF etc
Other Data Manipulation Tools:
· Data transfer
· Transferring data to SQL script as INSERT statement
· Transferring data to a SQL file with designated SQL format and encoding
· Data synchronization
· Structure synchronization
Schedule for Batch Job:
· Ability to set schedule on query execution, import/export, data transfer and data synchronization
· Schedule report printing
· Schedule to print report to files: PDF, Excel, HTML etc
· Sending notification e-mail for schedule task
· Ability to attach Export Wizard/Report result files in Batch Job notification email
· Notification email Support SSL/TLS
Server Security and Maintenance Services:
· Visual user management
· Visual privilege manager
· Ability to duplicate user, role
· Maintaining tables like Table Lock, Row Movement, Shrink Space, Table Move, Validate Table Structure and Collect Table Statistics
· Server Monitor to view and change system variables, to view server status information
Report Management Tools:
· Report Builder
· Report Viewer
Other Useful Features:
· ER Diagram view
· Ability to customize connection colorings
· Support of database wide search
· Objects search filter
· Backing up schema/table to SQL script
· Executing SQL script
· Duplicate/empty/truncate tables
· Create table/view shortcut on desktop
· Ability to create Favorites list
· Ability to set auto-save for Query, Function, etc
· Print Schema Structure
· Support of docking/tab windows
· Support of virtual grouping: provide logical organization over connections and objects
· Ability to run profile from command line
· Log files: keep track on the actions have been performed in Navicat
· Ability to copy Connection Information into Clipboard
Requirements:
· Pentium II processor or above
· 65 MB of available hard-disk space.
· Oracle
Limitations:
· 30 days trial
· Nag screen
