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" section)
 - Code formatting, folding and bracket matching
 - Two configurable levels of code completion, sortable code completion lists
 - 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
 - Transactio
 - Useful editor intentions

Note: Only language highlighting is supported by the PL/SQL editor for now.

...

Statement and database-method execution, compile engine for database programs (e.g. functions, procedures)
 - Execution of sql statements can be fired directly from the editor gutter
 - Sticky linkage between editor and execution (navigation from the editor to the result and backwards is ensured even if the file is being edited)
 - Sortable query results in tabular form
 - Export of query results to file or clipboard in several formats (sql insert statements, .xls, .csv)
 - Message window for failed statement executions
 - Executed statement preview window (useful when the underlying statement has been changed in editor)
 - Transaction awareness on data manipulation statements (commit and rollback controls are bening enabled for the corresponding connection)

Note: Configuration of execution processes is still pending.

...

Highlighted code editor for program-objects (e.g. functions) and views
 - Editor for database functions, procedures, packages, types and triggers
 - Database-view editor with 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 object was changed by a third party since it was last saved, user will be prompted for merging the versions) 
 - Support for creation of DDL files for database objects
 - DDL file mapping - locating and aggregating project .ddl 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 qualified navigation to code (to exact row and column numberposition) **

Data Editor


----** Oracle feature

Known issues

...