Databrid is a powerful tool that provides easy access to data and manipulation of data within an Oracle or MySql database. If you are a DBA, Developer, Analyst or anyone that uses an Oracle database, then Databrid’s many useful features will help increase your productivity.
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.
- 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).
