- Autocompletion of table column names.
- A connection (Oracle or MySql) is associated with an Sql Editor. An editors connection can be change or shared with another connection.
- Highlighting of words the same as the one currently under the cursor.
- Context Sensitive SQL and PLSQL editors.
- Automatic Case adjustment for keywords and functions (optional).
- Edit SQL and PLSQL files.
- Print editor functionality (with print preview).
- Commit and Roll back database changes.
- Build and execute Select statements in the editor and perform the following:
- View the output in a user friendly table.
- Save the output as a CSV (comma delimited file) or insert statements. Output can be sent to the clipboard or to a file.
- Count the number of records.
- Tune the Select Statement.
- Develop SQL and PLSQL statements. Oracle DBMS_OUTPUT output is captured into a separate area.
- Create, modify and delete database objects.
- Aliases can not be used to save typing. Type sw followed by shift-space and sw will be replaced by SELECT xx FROM yy WHERE zz. Aliases are defined in the preferences.
- Table/View data can be edited in the Sql Editor result view.
- Browse database objects for multiple users.
- Produce creation scripts for database objects.
- View information about database objects.
- You can now browse the database in more than one connection (Oracle or MySql).
- Table/View data can be edited in either the Browser table/view data views.
- SQL and PLSQL files can be edited with syntax highlighting and an optional automatic case adjustment for keywords and functions. Autocompletion of columns names is also available.
- The ability to use SQL statements to add additional information to CSV (delimited) files while binding in values from the CSV.
- The ability to manipulate the database using use information from a CSV file.
- You can now have more than one File processing tab open, each with its own independant connection (no problem with commits in this tab affecting other areas of Databrid).
Please go to the online help for more information.