|
Schema Browser / Visual Editing / DDL Object Scripting
|
|
|
Browsing |
Visual Editing |
DDL Scripting |
|
- Schema |
|
|
|
|
- Tables |
x |
x |
x |
|
- Views |
x |
x |
x |
|
- Aliases |
x |
x |
x |
|
- Nicknames |
x |
x |
x |
|
- Sequences |
x |
x |
x |
|
- Indexes |
x |
x |
x |
|
- Triggers |
x |
x |
x |
|
- Packages |
x |
|
|
|
- Stored Procedures |
x |
x |
x |
|
- User Defined Functions |
x |
x |
x |
|
- Materialized Views |
x |
x |
x |
|
- User Defined Datatypes |
x |
x |
x |
|
- Management |
- Processes
|
x |
|
|
- Locks / Process ID
|
x |
|
|
|
- Locks / Object |
x |
|
|
|
- Security |
|
- Users |
x |
x |
x |
|
- Object Filtering |
|
|
|
|
| |
|
Query Window
|
|
- MultiTab Mode / SplitPane Mode
|
|
- Query Popup Window
|
|
- SQL Script Editor
|
- Cut/Copy/Paste/Undo/Redo/Select All/Find/Replace
- To Lower Case/To Upper Case/Goto Line
- Configurable tab expansion, tab size and space conversion
- Configurable SQL Abbreviations, user-defined autocompletion
- In-line Diff indicator marks differences between current edit and latest source control update
|
|
- Query Window
|
- Parse Script
- Execute Script
- Execute Current Statement
- Execute Edit
- Execute Explain Plan
- Control of Auto-commit/Commit/Rollback
|
|
- Auto Completion
|
|
- Auto Describe
|
|
- Shortcut Toolbar
|
|
- Local SQL Permissions
|
|
- SQL Formatter
|
|
- SQL Automation
|
- Introduce Insert/Update/Delete/Select Statements
- Introduce Columns/Qualified Columns/Value Stubs
- Comment/Uncomment statements/lines
|
|
- Syntax Coloring
|
- Color configuration for SQL 92/99 Keywords, Oracle specific keywords, data types,
system functions, system tables, quoted strings, comments
|
|
- Results
|
- Max results & max column retrieval configurable
- Text (configurable display of SQL Statement, query statistics, warning headers)
- Text History
- DBMS_OUTPUT
- Grid (configurable alternating colors)
and Grid Chart Results
- Client Statistics (Time stats: total processing, client processing, server wait,
parse, execution)
- Pivot Results (With Pivot Grids and Pivot Charts)
|
|
- Save Results
|
- Delimited Data
- INSERT Statement
- XML Document
- HTML Document
- Excel Worksheet
|
| |
|
Scripts Browser
|
|
- Multi-mount point script browser
|
|
- Filterable script folders
|
| |
|
Table Data Editor
|
|
- Visually insert/modify/delete/undo recordset results
|
|
- Preview SQL changes before commiting
|
|
- Save changes to database or SQL statements to file
|
|
- CLOB/Large Text editor
|
|
- Table Modifications Log, exportable to spreadsheets for tracking changes |
| |
|
SQL History and Archive
|
|
- History storage of executed SQL statements and scripts, stored in a directory that can be analyzed for statistics and performance, or for audit purposes (Sarbanes-Oxley).
|
| |
|
Tools
|
|
- Import Tool
|
- Import delimited data files
- Import to database or INSERT statements
|
|
- Export Tool
|
|
- Export to delimited data or INSERT statements
|
|
- Schema Script Generator
|
|
- Script a complete or partial database to file, including CREATE, DROP DDL and INSERT DML.
|
|
- Server Script Generator |
|
- Server Script Generator allows a user to generate SQL scripts for server objects such as databases, users, roles, alerts, jobs, tablespaces etc. |
|
- ER Modeler / ER Diagram Generator
|
|
- Generate an ER Diagram from a current database schema with a few clicks of a button.
|
|
- Draw an ER Diagram and have the ER Modeler script the associated schema information and relationships into a database. |
|
- Compare Tool |
- Schema Compare
- Tab Compare
- Directory Compare
- File Compare
- Copy Compare
- Result Compare |
| |
| ER Modeler |
|
- Create, Edit and View database schema relationships using entity relationship diagrams . |
| |
|
Configurable Look and Feel
|
- Aqua Data Studio
- Aqua Data Studio - 3D
- Aqua Data Studio - XP
- Mac OSX (only Mac OSX)
- Windows
- Windows Classic (only Windows XP)
- Metal
- CDE/Motif
|
| |
|
Source Control
|
|
- Subversion (SVN) |
|
- Repository Browser |
|
- CVS |
|
- Repository Browser |
