Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Dialect sensitive editor for SQL and for  Procedural-SQL script files (.sql, .plsql) providing advanced editing capabilities.
 - Language highlighting configurable in the "Colors & Fonts" IDE settings section
 - Code formatting, folding and bracket matching
 - Qualified code completion suggesting only suitable variants for the invoking position (it suggests only keywords and objects which are allowed to occur at the given position) *** 
 - Two configurable levels for code completion (to narrow down the suggested variants to the desired extent) 
 - Sortable variant-lists on code completion invocation
 - Error highlighting for incomplete statements or invalid references to database entities 
 - Basic structure projection in the "Structure" tool window
 - Statement execution triggers on editor gutter
 - Editor intentions (statement execution and selection of connection/schema for the current editor)
 - Navigation to object browser for resolved identifiers
 - Navigation within editor for aliases

...

Highlighted code editor for program-objects (e.g. functions) and views
 - Editor for database functions, procedures, packages, types and triggers
 - Qualified editor for database views (advanced editing capabilities like code completion, folding, navigation, error highlighting)
 - Show changes facility (diff visualization for local changes and changes against database)
 - Basic team coding support to prevent blind overwriting on concurrent editing (if the edited object was changed by a third party since it was last saved, user will be prompted to merge the versions) ***   
 - Support for creation of DDL files for database objects
 - DDL file mapping - locating and aggregating project .ddl files with the database objects being edited (ddl files are automatically updated when object is edited) *** 
 - Firing compile operation after updating changes to database **
 - Compiler error messages in the execution console providing navigation to code (to exact row and column position) **
 - Structure projection in the "Structure" tool window (not navigable)

...

Tabular dataset editor for manipulating data in tables and editable views
 - Enhanced cell editors for several data types (data choosers, calendar, large text editor)
 - Input validation and error highlighting (erroneous inputs are leniently notified by a lightweight error pop-up) *** 
 - Data sorting (click on column header will switch the sorting order)
 - Gutter highlighting for unsaved changes (inserted, changed or removed entries are emphasized in the editor gutter)
 - Data export to file or to clipboard in several formats (sql insert statements, .xls, .csv)
 - Flexible data filtering capabilities (simple - list of conditions joined with AND or OR; custom - sql editor for freestyle "where" condition)
 - Quick filter suggestions (e.g. "filter by column value") *** 
 - Transaction awareness when changing data (commit and rollback controls are being enabled for the corresponding connection)
 - Navigable structure projection in the "Structure" tool window
 - Smart editing (cell becomes editable right after being selected to skip annoying "double-click to edit") ***

back

** Oracle specific feature *** Productivity highlight

Known issues

On the pipe

Change notes

...