| |
|
|
Home Products Navicat for Oracle Version History
|
Version History
| Feature |
v. 8.x |
v. 9.0 |
v. 9.1 |
v. 10.0 |
| Support object list in SQL Editor |
|
|
|
|
| SQL Minifier |
| Database wide search |
| ER Diagram view |
| Data Modeling Tool |
| Connection Coloring |
| Support of Privileges Manager |
| Enhanced user and role management |
| Data Synchronization performance improved with new engine |
| Support of Keep Connection Alive for Oracle |
| History Log Viewer |
| Ability to set favorites list |
| Object filter |
| Ability to set auto save in Query, Function etc |
| Ability to copy SQL statement with quote in Query |
| Custom sorting in Table Viewer |
| Support of sending SSL/TLS e-mail for schedule task |
| Code folding |
| Zoom in/Zoom out |
| Matched brace/bracket highlighting feature |
| Word completion for SQL editors |
| Support unicode character reports |
| SQL Beautifier |
| Support of Code Outline |
| Support of PL/SQL Code Debugger |
| Export/Import Connections |
| Build-in Oracle Instant Client |
| Log files: keep track on the actions have been performed in Navicat |
| Code completion for SQL editors |
| Support of virtual grouping: provide logical organization over objects |
| Schedule to sent notification e-mail with file attachment - Export Wizard/Report result files |
| Schedule to print report to files: PDF, Excel, HTML etc |
| Schedule report printing |
| Incremental search |
| Support of multi-resultset in Query, Stored Procedure |
| Ability to preview SQL before execution |
| Ability to set NULL and Empty String as default field value |
| Form view |
| Create table/view shortcut on desktop |
| Backup connection informations |
| Support of Preview and Explain in Query/View Designer |
| Maintain tables |
| Server Monitor to view/modify server status information and system variables |
| Visual user manager to administer users/groups and privileges |
| SQL console |
| Ability to run profile from command line |
| Ability to set schedule on query execution, import/export, data transfer and data synchronization |
| Report Builder/Viewer |
| Executing SQL script |
| Backing up database/schema/table to SQL script |
| Structure synchronization |
| Data synchronization |
| Ability to transfer data to a SQL file with designated SQL format and encoding |
| Transfering data to SQL script as INSERT statement |
| Data transfer |
| Exporting data to most popular formats: TXT, CSV, MS Excel, MS Access, HTML, XML, PDF, DBF etc |
| Importing data from other file formats : TXT, CSV, MS Excel, MS Access, XML, DBF etc |
| Importing data from ODBC: MSSQL, Oracle etc |
| Print database/schema/table Structure |
| Ability to create parameter queries |
| Multiple SQL editors with syntax highlighted feature |
| Visual SQL builder to facilitate the process of building complicated queries |
| Filtering and sorting records |
| Copying and pasting selected records |
| Customize display formats |
| Formatting table grid |
| Ability to set number of records showing on each page |
| Support of foreign key data selection: locate the available values from the reference table |
| Ability to show/hide ROWID |
| Text, Hex and BLOB/BFile viewer/editor |
| Grid view |
| Duplicate/empty/truncate tables |
| Backup connection informations |
| Support of docking/tab windows |
| Support of character set and uincode |
| Create/drop schemas |
| Support of physical attributes |
| Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin. |
| Managing directories, tablespaces, public database links and public synonyms |
| Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers |
| Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions |
| Connection to Oracle Server through HTTP |
| Support of TNS Connection |
| Support of Basic Connection |
| Multiple local/remote Oracle server connections |
| Supports Oracle Servers 8.1 or above |
| Working with Vista and Windows 7 |
| Feature |
v. 8.x |
v. 9.0 |
v. 9.1 |
v. 10.0 |
| Support object list in SQL Editor |
|
|
|
|
| SQL Minifier |
| Connection Coloring |
| Database wide search |
| ER Diagram view |
| Data Modeling Tool |
| Support of Privileges Manager |
| Enhanced user and role management |
| Data Synchronization performance improved with new engine |
| Support of Keep Connection Alive for Oracle |
| History Query Log Viewer |
| Ability to set favorites list |
| Object filter |
| Ability to set auto save in Query, Function etc |
| Ability to copy SQL statement with quote in Query |
| Custom sorting in Table Viewer |
| Code folding |
| Zoom in/Zoom out |
| Matched brace/bracket highlighting feature |
| Word completion for SQL editors |
| SQL Beautifier |
| Support of Code Outline |
| Support of PL/SQL Code Debugger |
| Export/Import Connections |
| Build-in Oracle Instant Client |
| Log files: keep track on the actions have been performed in Navicat |
| Code completion for SQL editors |
| Support of virtual grouping: provide logical organization over objects |
| Sending notification e-mail for schedule task, with option to attach file output from Export Wizard or Data Transfer. |
| Incremental search |
| Ability to preview SQL before execution |
| Ability to set NULL and Empty String as default field value |
| Form view |
| Create table/view shortcut on desktop |
| Backup connection informations |
| Support of Preview and Explain in Query/View Designer |
| Maintain tables |
| Server Monitor to view/modify server status information and system variables |
| Visual user manager to administer users/groups and privileges |
| SQL console |
| Ability to run profile from command line |
| Ability to set schedule on query execution, import/export, data transfer and data synchronization |
| Executing SQL script |
| Backing up database/schema/table to SQL script |
| Structure synchronization |
| Data synchronization |
| Ability to transfer data to a SQL file with designated SQL format and encoding |
| Transfering data to SQL script as INSERT statement |
| Data transfer |
| Exporting data to most popular formats: TXT, CSV, XML and DBF |
| Importing data from : TXT, CSV, XML and DBF |
| Importing data from ODBC: MSSQL, Oracle etc |
| View database/table structure in HTML format |
| Ability to create parameter queries |
| Multiple SQL editors with syntax highlighted feature |
| Visual SQL builder to facilitate the process of building complicated queries |
| Filtering and sorting records |
| Copying and pasting selected records |
| Customize display formats |
| Formatting table grid |
| Ability to set number of records showing on each page |
| Support of foreign key data selection: locate the available values from the reference table |
| Ability to show/hide ROWID |
| Text, Hex and BLOB/BFile viewer/editor |
| Grid view |
| Duplicate/empty/truncate tables |
| Support of docking/tab windows |
| Support of character set and uincode |
| Create/drop schemas |
| Support of physical attributes |
| Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin. |
| Managing directories, tablespaces, public database links and public synonyms |
| Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers |
| Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions |
| Connection to Oracle Server through HTTP |
| Support of TNS Connection |
| Support of Basic Connection |
| Multiple local/remote Oracle server connections |
| Supports Oracle Servers 8.1.7 or above |
| Compatible with Mac OS X Leopard |
| Feature |
v. 8.x |
v. 9.0 |
v. 9.1 |
v. 10.0 |
| Support object list in SQL Editor |
|
|
|
|
| SQL Minifier |
| Database wide search |
| ER Diagram view |
| Data Modeling Tool |
| Connection Coloring |
| Support of Privileges Manager |
| Enhanced user and role management |
| Data Synchronization performance improved with new engine |
| Support of Keep Connection Alive for Oracle |
| History Log Viewer |
| Ability to set favorites list |
| Object filter |
| Ability to set auto save in Query, Function etc |
| Ability to copy SQL statement with quote in Query |
| Custom sorting in Table Viewer |
| Support of sending SSL/TLS e-mail for schedule task |
| Code folding |
| Zoom in/Zoom out |
| Matched brace/bracket highlighting feature |
| Word completion for SQL editors |
| SQL Beautifier |
| Support of Code Outline |
| Support of PL/SQL Code Debugger |
| Export/Import Connections |
| Build-in Oracle Instant Client |
| Log files: keep track on the actions have been performed in Navicat |
| Code completion for SQL editors |
| Support of virtual grouping: provide logical organization over objects |
| Schedule to sent notification e-mail with file attachment - Export Wizard result files |
| Incremental search |
| Support of multi-resultset in Query, Stored Procedure |
| Ability to preview SQL before execution |
| Ability to set NULL and Empty String as default field value |
| Form view |
| Create table/view shortcut on desktop |
| Backup connection informations |
| Support of Preview and Explain in Query/View Designer |
| Maintain tables |
| Server Monitor to view/modify server status information and system variables |
| Visual user manager to administer users/groups and privileges |
| SQL console |
| Ability to run profile from command line |
| Ability to set schedule on query execution, import/export, data transfer and data synchronization |
| Executing SQL script |
| Backing up database/schema/table to SQL script |
| Structure synchronization |
| Data synchronization |
| Ability to transfer data to a SQL file with designated SQL format and encoding |
| Transfering data to SQL script as INSERT statement |
| Data transfer |
| Exporting data to most popular formats: TXT, CSV, HTML, XML, DBF, MS Excel etc |
| Importing data from: TXT, CSV, XML, DBF etc |
| Print database/schema/table Structure |
| Ability to create parameter queries |
| Multiple SQL editors with syntax highlighted feature |
| Visual SQL builder to facilitate the process of building complicated queries |
| Filtering and sorting records |
| Copying and pasting selected records |
| Customize display formats |
| Formatting table grid |
| Ability to set number of records showing on each page |
| Support of foreign key data selection: locate the available values from the reference table |
| Ability to show/hide ROWID |
| Text, Hex and BLOB/BFile viewer/editor |
| Grid view |
| Duplicate/empty/truncate tables |
| Backup connection informations |
| Support of character set and uincode |
| Create/drop schemas |
| Support of physical attributes |
| Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin. |
| Managing directories, tablespaces, public database links and public synonyms |
| Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers |
| Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions |
| Connection to Oracle Server through HTTP |
| Support of Basic Connection |
| Multiple local/remote Oracle server connections |
| Supports Oracle Servers 8.1 or above |
|
|
|