|
Schema Browser / Visual Editing / DDL Object Scripting
|
|
|
Browsing |
Visual Editing |
DDL Scripting |
|
- Schema |
|
|
|
|
- Tables |
x |
x |
x |
|
- Views |
x |
x |
x |
|
- Indexes |
x |
x |
x |
|
- Triggers |
x |
x |
x |
|
- Procedures |
x |
x |
x |
|
- Functions |
x |
x |
x |
|
- User Datatypes |
x |
x |
x |
|
- Defaults |
x |
x |
x |
|
- Rules |
x |
x |
x |
|
- Users |
x |
x |
x |
|
- Roles |
x |
x |
x |
|
- Management |
- Backups
|
x |
|
|
- Alters
|
x |
|
|
- Operators
|
x |
|
|
- Jobs
|
x |
|
|
- Server Logs
|
x |
|
|
- Sessions
|
x |
|
x |
- Locks by Session ID
|
x |
|
|
|
- Locks by Object |
x |
|
|
|
- Storage |
|
- Databases |
x |
x |
x |
|
- Security |
|
- Logins |
x |
x |
x |
|
- Server Roles |
x |
x |
x |
|
- Mountable Script Browser in Schema Browser
- Object filtering
|
| |
|
Procedure Editor
|
|
- The Procedure Editor provides a compilation and execution environment for the development
of procedures, functions, and packages. Users can compile procedures, view results and jump to
errors to assist in the refinement of their executable code.
|
| |
|
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
|
|
- 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)
- Grid and Grid Chart Results |
|
- 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
|
| |
|
Visual Explain Plan
|
|
- Explain Grid
|
- Color coding for Critical Path, Critical Node and Critical Operator
- Customizable columns
|
|
- Explain Diagram
|
- Color coding for Critical Path, Critical Node and Critical Operator
- Zoom In/Zoom Out
|
|
- Explain WhiteBoard
|
| |
|
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 Diagram Generator
|
|
- Generate an ER Diagram from a current database schema with a few clicks of a button.
|
|
- 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 . |
| |
| SQL Debugger for SQL Server |
|
- debugger for procedure packages and scripts |
| |
| DBA Tools |
|
-Instance Manager |
|
-Storage Manager |
|
-Security Manager |
|
-Session Manager |
|
-SQL Agent Manager |
| |
|
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 |
