Data Browser and Editor

  • Browse data stored in your tables and views.
  • Edit data via datatype-specific forms.
  • Comfortably select values from lookup tables.
  • Set number of records that should be displayed in grid and explore larger set of rows.

Blobs Supported

  • Open data stored in blobs in associated applications.
  • Export blobs to files.
  • Set blob to null easily.

Export and Import

  • Export data to SQL or CSV via wizards.
  • Limit exported data to meaningful formats (skip blobs etc.)
  • Select columns that should be exported.
  • Set advanced options, e.g. disable triggers.

Wizards for New Objects

  • Create new objects using wizards.
  • Define tables, columns, constraints...
  • Either create the object in database or generate code for detailed specification and manual execution.

Advanced Content Assist

  • Take advantage of advanced Content Assist (Intellisense).
  • Proposals are sorted by references and relevance.
  • See referenced tables, get proposals for joins.
  • Generate aliases automatically
  • See VIDEO

Code Validation

  • Validate code on-the-fly.
  • See a list of suggestions, expected statements.
  • Visually navigate to error positions in large files.
  • SQL Problems View shows errors thrown by database platform.

Statements Execution

  • Execute all statements at once or choose position from where the code should be executed.
  • Run commands with Explain Plan.
  • Switch to another database connection to execute the same statement on different database.

Integration with Java

  • View SQL statements defined in Java files.
  • Recognize valid statements as well as errors.
  • Sort and group items by type (error, warning...) or source (Java file)
  • Easily send your SQL statements to SQL Worksheet.
  • See VIDEO

Navigation from Java to Database

  • Navigate from Java files to database objects.
  • See object definition.
  • View dependencies in separate view.
  • Edit selected object in appropriate editor.

Visual Object Modifications

  • Explore existing database structure.
  • Create new or modify existing objects.
  • Add constraints, comments, default values...

Quick Search

  • Quickly find objects using smart search.
  • Press CTRL+SHIFT+D to open search form.
  • Specify first letters of your object names to get results.
  • Use camel case search and more.

Run Stored Procedures and Functions

  • Run Stored procedures and functions.
  • Specify input values visually.
  • Execute the same object on different database connection.

Dependencies

View dependencies and see references found in:

  • Database
  • Java files
  • Open SQL worksheets

Refactoring

Change database object name and modify

  • Related Database objects
  • Occurences in Java files and open SQL worksheets

Deployment

  • Deploy objects to linked database or to any other database using selected database connection.
  • See status of your objects and easily recognize outdated objects in your projects.

Versioning

  • Use Eclipse Local History feature to see code differences or use Version Managers supported by Eclipse.
  • See how the code changed in time.
  • Compare sources and see differences quickly.

Supported Databases

  • Oracle Database
  • MySQL
  • PostgreSQL

Note: Some advanced features are available for Oracle database only.