- Details
- Created: 19 April 2013
|
Win
|
Win
|
Win
|
Mac
|
Mac
|
Mac
|
Linux
|
Linux
|
Linux
|
|
|
^Enterprise Edition. #Standard Edition. *Essentials Edition. |
|||||||||
| Oracle Servers 8.1 or above (Mac OS X Edition starts from Oracle 8.1.7) |
|
|
|
|
|
|
|
|
|
| Multiple local/remote server connections |
|
|
|
|
|
|
|
|
|
| Basic connection |
|
|
|
|
|
|
|
|
|
| TNS connection |
|
|
|
|
|
|
|||
| Connet server through SSH |
|
|
|
|
|
|
|
|
|
| Keep connection alive |
|
|
|
|
|
|
|
|
|
| Export/import connection settings |
|
|
|
|
|
|
|
|
|
| Show interactive and real-time debugging information |
|
|
|
|
|
|
|||
| Set simple and complex breakpoints |
|
|
|
|
|
|
|||
| Step through a function, i.e. Step Into, Step Over and Step Out |
|
|
|
|
|
|
|||
| Inspect variables and expressions |
|
|
|
|
|
|
|||
| Stack traces |
|
|
|
|
|
|
|||
|
|
|||||||||
| Grid view |
|
|
|
|
|
|
|
|
|
| Form view |
|
|
|
|
|
|
|||
| TEXT, Hex, BLOB and BFile viewer/editor |
|
|
|
|
|
|
|
|
|
| Code-highlight in Memo viewer |
|
|
|
|
|
|
|||
| Web viewer for HTML codes data |
|
|
|
|
|
|
|||
| Box selection and multi-cell editing |
|
|
|
|
|
|
|||
| Copy and paste selected records |
|
|
|
|
|
|
|
|
|
| Copy selected records as INSERT/UPDATE statements |
|
|
|
|
|
|
|||
| Customize display formats |
|
|
|
|
|
|
|||
| Incremental search, sort and format table grid |
|
|
|
|
|
|
|
|
|
| Search columns |
|
|
|
|
|
|
|
|
|
| Find and replace |
|
|
|
|
|
|
|
|
|
| Show/hide table ROWID |
|
|
|
|
|
|
|
|
|
| Foreign key data selection: locate the available values from the reference table |
|
|
|
|
|
|
|||
| Filter records |
|
|
|
|
|
|
|||
| Set number of records showing on each page |
|
|
|
|
|
|
|
|
|
|
|
|||||||||
| Visual SQL Builder |
|
|
|
|
|
|
|||
| Create parameter queries |
|
|
|
|
|
|
|
|
|
| Code completion |
|
|
|
|
|
|
|||
| Code outline |
|
|
|
|
|
|
|||
| SQL Code Beautifier/Minifier |
|
|
|
|
|
|
|||
| Multiple SQL editors with syntax highlighted feature |
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
| Preview SQL before execution |
|
|
|
|
|
|
|
|
|
| Return multi-resultsets |
|
|
|
|
|
|
|
|
|
| SQL*Plus |
|
|
|
|
|
|
|||
|
|
|||||||||
| Reverse engineering |
|
|
|
||||||
| Build model with multiple schemas |
|
|
|
||||||
| Several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
||||||
| Create/edit/drop database objects, visually set relationships between them |
|
|
|
||||||
| Align and distribute database objects |
|
|
|
||||||
| Search tables in diagram |
|
|
|
||||||
| Auto layout |
|
|
|
||||||
| Add vertices, layers, images and notes/labels |
|
|
|
||||||
| Zoom in/out for ER diagram |
|
|
|
||||||
| Compare and synchronize database/model |
|
|
|
||||||
| Generate complex SQL/DDL |
|
|
|
||||||
| Multi-page print preview |
|
|
|||||||
| Print database diagrams to PDF file |
|
|
|
||||||
| Save database diagrams as a graphic file, i.e. PNG, SVG |
|
|
|
||||||
|
|
|||||||||
| Import data from ODBC |
|
|
|
|
|||||
| Import data from MS Excel |
|
|
|
|
|||||
| Import data from MS Access |
|
|
|
|
|||||
| Export data to MS Excel |
|
|
|
|
|
|
|||
| Export data to MS Access |
|
|
|
|
|||||
| Export data to HTML |
|
|
|
|
|||||
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON etc |
|
|
|
|
|
|
|
|
|
| Import/export data from/to most popular formats: DBF etc |
|
|
|
|
|
|
|||
|
|
|||||||||
| Data transfer |
|
|
|
|
|
|
|||
| Transfer data to SQL script as INSERT statements |
|
|
|
|
|
|
|||
| Transfer data to a SQL file with designated SQL format and encoding |
|
|
|
|
|
|
|||
| Data synchronization |
|
|
|
|
|
|
|||
| Structure synchronization |
|
|
|
|
|
|
|||
| Data Pump Export |
|
|
|
|
|
|
|||
| Data Pump Import |
|
|
|
|
|
|
|||
| 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 |
|
||||||||
| Send notification e-mail for schedule task |
|
|
|
|
|
|
|||
| Attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
|
|
|
|||
| Notification email supports SSL/TLS |
|
|
|
|
|
|
|||
| Visual user management |
|
|
|
|
|
|
|
|
|
| Visual privilege manager |
|
|
|
|
|
|
|
|
|
| Duplicate user, role |
|
|
|
|
|
|
|
|
|
| Maintain database/schema objects |
|
|
|
|
|
|
|
|
|
| Server Monitor to view or change system variables and server status information |
|
|
|
|
|
|
|||
| Report Builder |
|
||||||||
| Report Viewer |
|
||||||||
| ER Diagram view |
|
|
|
|
|
|
|||
| Customize connection colorings |
|
|
|
|
|
|
|
|
|
| Database wide search |
|
|
|
|
|
|
|||
| Connection tree filter and objects search filter |
|
|
|
|
|
|
|
|
|
| Backup schema/table to SQL script |
|
|
|
|
|
|
|
|
|
| Execute SQL script |
|
|
|
|
|
|
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
|
|
|
|
|
|
| Create table/view shortcut on desktop |
|
|
|
|
|
|
|||
| Favorites list |
|
|
|
|
|
|
|||
| Auto-save for Query, Function, etc |
|
|
|
|
|
|
|
|
|
| Print schema structure |
|
|
|
|
|
|
|||
| Dock/tab windows |
|
|
|
|
|
|
|
|
|
| Virtual grouping: provide logical organization over connections and objects |
|
|
|
|
|
|
|||
| Run profile from command line |
|
|
|
|
|
|
|||
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
|
|
|
|
|
|
| Copy Connection Information into Clipboard |
|
|
|
|
|
|
|
|
|