Databrid - Features
Sql Editor
- 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.
- ...
Schema Browser
- 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.
- ...
File
- 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.